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.