EMS logo


SQL Manager for Oracle

Notre statut de partenariat

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

Documentation en ligne

Adding a new condition

Suppose we need to select data from the sample table EMPLOYEES to view the list of IT specialists hired after 1/15/2007. These criteria are applied to the HIRE_DATE, the DEPARTMENT_ID and the JOB_ID fields.


Click press the button to add a new condition - this will add a new condition to the criteria. Alternatively, you can click the Filter button and select the Add Condition popup menu item.


Filter Builder dialog - Adding a new condition


You can also add the filter condition from the grid with Shift button.


See also:

Invoking the Filter Builder dialog

Setting filter criteria

Setting filter operator

Setting filter criteria values

Adding a new group

Setting group operator

Applying filter conditions