Char/VarChar2 |
- EQ - Equal to
- FLIKE - Starts with
- LIKE - Contains
- GT - Greater than
- LT - Less than
- NE - Not equal to
|
Number |
- BETWEEN - Range of values
- EQ - Equal to
- GE - Greater than or equal to
- GT - Greater than
- LE - Less than or equal to
- LT - Less than
- NE - Not equal to
|
Date |
- DATERANGE - Range of dates
- EQ - Equals
- GE - Greater than or equal to
- GT - Greater than
- LE - Less than or equal to
- LT - Less than
- NE - Not equal to
|
Date-Time |
- BETWEEN - Range of dates
- EQ - Equals
- GE - Greater than or equal to
- GT - Greater than
- LE - Less than or equal to
- LT - Less than
- NE - Not equal to
|
Note: For nullable columns where the
column or attribute is set to Nullable in the entity XML, you can
use the following query types: - ISNULL - Return records that are null.
- NOTNULL - Return records that are not null.
For non-nullable columns, you can use the VOID query type, which
returns all the records of type void.
|