Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

Criteria Tab

  1. Add tables, views and synonyms to the Model Area.
  2. In these tables, views and synonyms, select the columns you want to add to the Criteria tab. Only Selected columns appear on the Criteria tab.

TIP: To rearrange the order of the columns on the Criteria tab, drag and drop them left or right.

 

Field Description

Only fetch unique records

Select to apply the DISTINCT command to the query.

Schema

The schema cannot be edited.

Null Value Subst.

Double click in the cell to enter a value to substitute for any null values.

To clear the cell, highlight it and press Delete.

Aggregate F.

Double click in the cell to select an aggregate column function, such as Average, Count, Max, Min, or Sum.

To clear the cell, highlight it and press Delete.

Where Cond.

Double-click in the cell to open the WHERE Definition dialog.

Section Description
Conditions Set a condition which tests if a column is equal to (or <, >, <=, >=, <>, LIKE, BETWEEN) a constant or another field _or_ a condition where the selected field is in a sub query.
Clear Form Click to reset the dialog box and begin the WHERE condition again.
Remove Condition Click to remove the WHERE definition.

 

TIP: A quick way to remove the WHERE definition is to highlight the cell and press Delete.

Or

Double-click in the cell to open the WHERE Definition dialog (as above).

This WHERE criteria will be OR'ed together with the above WHERE criteria.

If you want to AND multiple column criteria together, then select Expert from the WHERE Definition dialog. For more information, see Global WHERE Conditions Window.

Group By

Double-click in the cell to select it as a GROUP BY column.

A number in parentheses indicates the order of the columns in the GROUP BY clause.

See also The Having Cond. cell.

To clear the cell, highlight it and press Delete.

Having Aggregate

Double click in the cell to select an aggregate column function (such as Average, Count, Max, Min, or Sum) for the HAVING clause.

This allows for the following type of query:

SELECT emp.job_id

FROM employee emp

GROUP BY emp.job_id

HAVING ((AVG (emp.salary) > 1500))

To clear the cell, highlight it and press Delete.

Having Cond.

Double click in the cell to open the GROUP BY Definition dialog.

Note: Requires a value in the Group By cell. To create more complex Having conditions see Global HAVING Conditions Window for more information.

To clear the cell, highlight it and press Delete.

Sort

Double click in the cell to sort this column as Ascending, Descending, or no sort.

To clear the cell, highlight it and press Delete.

Visible

Double click in the cell to have it be visible / hidden. When visible the column is returned in the column list.

Field Alias

Double click in the cell to change the field name alias.

Table Alias

Double click in the cell to enter a value for the table alias.

To clear the cell, highlight it and press Delete.

 

Right-click over the Criteria grid:

Menu Description

Suppress Current Column

Remove this column from the query

Best Fit (All Columns)

Set the column width of the Criteria grid to show all text

Default Width (All Columns)

Set the column width of the Criteria grid to the default width

Copy Query Grid Image to Clipboard

Copy the Criteria grid to the clipboard

 

Related Topics

Module: SQL Modeler

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating