FME considers an Oracle Spatial dataset to be a database containing a collection of relational tables together with their geometry,GeoRaster, or point cloud columns. The tables must be defined in the mapping file before they can be read. Arbitrary WHERE clauses and joins are fully supported. When using the object-relational model, an entire arbitrary SQL SELECT statement may also be used as a source of results.
When reading 3D spatial data, it is important to enable the Read 3D Polygons as Faces format parameter.