Online Documentation for SQL Manager for Oracle

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.