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.
General
All feature types share similar General parameters, which may include the Feature Type Name, Reader or Writer Name, and Geometry.
In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept a Table Qualifier prefix on the output table feature type.
See Editing Writer Feature Types for more information.
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.