Chatta subito con l'assistenza
Chat con il supporto

SQL Navigator for Oracle 7.4 - Release Notes

Global WHERE Conditions Window

Add, Edit, Delete global where conditions as per the toolbar.

The Add and Edit buttons open the Global WHERE Definition dialog. Global Where entries are in the form of <expression1> <operator> <expression2>.

TIP: You could alternatively populate the WHERE clause via the Criteria Tab. Entries into the cells of the Criteria tab should be in the form of <operator> <expression2>.

 

Example

Construct the following query

SELECT dept.deptno, dept.dname, dept.loc

FROM scott.dept

WHERE ((dept.deptno BETWEEN 1 AND 25)

AND (dept.deptno < 40)

AND (dept.loc IS NOT NULL)

Follow the numbered steps

  1. Open the SQL Modeler (as SCOTT/TIGER).
  2. Double-click DEPT to add it to the model.
  3. Right-click DEPT and choose Select All.
  4. On the criteria tab, double click the Where Cond. cell under DEPTNO.
  5. Choose < and fill in the value 40. Click OK.
  6. On the criteria tab, double click the Where Cond. cell under LOC and then choose the Expert tab and click Yes at the warning dialog.
  7. In the top edit box, enter IS NULL. Click OK.
  8. On the criteria tab, double-click the OR cell under LOC. Choose the Expert tab and click Yes at the warning dialog.
  9. In the top edit box, enter = 'CHICAGO'
  10. In the table model area (the area around the table images), right-click and choose SQL>Global Where
  11. In the top edit box, enter Data Field DEPT.DEPTNO. Click OK.
  12. From the SQL Function panel, select BETWEEN _Const_ AND _Const_. Replace the constants with values, for example 1 and 25 respectively. Click OK twice.
  13. View the generated query. It should appear as described above.

 

Related Topics

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione