Oracle Non-Spatial Reader Feature Type Parameters

To access feature type parameters, click the gear icon on a feature type in the workspace. This opens the Feature Type Parameter Editor.

Tip To always display the editor in FME Workbench, you can select View > Windows > Parameter Editor.

General

All feature types share similar General parameters, which may include Feature Type Name, Reader or Writer information, and Geometry.

In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept Table or Index Qualifier prefixes on the output table feature type.

These parameters apply only to a selected feature type, not to the entire reader.

Important If a feature type parameter corresponds to a reader-level parameter, then the reader parameter will be ignored and the feature type parameter will be used.

SQL SELECT Statement

This parameter specifies a SQL SELECT query to be used as the source for the results. If this is specified, the Oracle Non-Spatial reader will execute the query, and use the resulting rows as the features instead of reading from the table <layerName>.

All returned features will have a feature type of <layerName> and an attribute for all columns selected by the query.

The SQL WHERE Clause reader parameter is ignored if this parameter is supplied.

SQL Where Clause

This parameter specifies the SQL WHERE clause applied to the attributes of the layer’s features to limit the set of features returned. If this is not specified, the value of the WHERE Clause reader parameter is used. If nothing is specified, all rows in the table will be read and returned as individual features.

Note that this parameter does not include the word WHERE.