FME considers an Oracle dataset to be a database containing a collection of relational tables. 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.