EMS logo

Products Navigation

SQL Query for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Query for Oracle

On-line Documentation

Setting filter criteria values

Next, we need to specify value '10/1/2007' for the IS GREATER THAN operator.


Similarly, if, for example, we need to get the list of employees hired during the 9/1/2007 - 10/1/2007 term, we set the BETWEEN filter operator (this will add two empty value boxes to specify the inclusive range for the BETWEEN condition) and specify the range for the operator, i.e. the '9/1/2007' and the '10/1/2007' values in the corresponding value boxes.


It is possible to set the date value manually by typing it in, or via the date editor which is activated when you click the value box.


Filter Builder dialog - Setting filter criteria values


Editors used in value boxes are determined by the data type assigned to the corresponding columns.


See also:

Invoking the Filter Builder dialog

Adding a new condition

Setting filter criteria

Setting filter operator

Adding a new group

Setting group operator

Applying filter conditions