EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

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