Oracle Non-Spatial Reader Feature Type Format Parameters
To access feature type parameters, click the gear icon on a feature type in the workspace to open the Feature Type Parameter Editor. To always display the editor in Workbench, you can select View > Windows > Parameter Editor.
All feature types share similar General Parameters. This includes Name and Writer Name. From here, you can also control Dynamic Properties.
These parameters apply only to a selected feature type, not to the entire reader.
Note: 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.
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.
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.