I am new in GIS, I need to generate source and target i.e.: Oracle Spatial 3D Code And PostGIS 3D code for development team as they are developing a conversion tool and they need patterns to implement in the tool,

However i am not able to find any good resources to generate Oracle Spatial 3D Code.

Generated below PostGIS code but PGAdmin is giving below error.

QGIS is also not showing any geometry when fetching this table in QGIS.

Can i get some real time Oracle Spatial 3D geometries or 3D shapefiles ?

So that i can create shape files or GeoJSON files by loading them in Oracle Spatial Studio and use those shape files or GeoJSON files to generate PostGIS code after uploading those shape files in QGIS. QGIS can generate PostGIS code.