サポートと今すぐチャット
サポートとのチャット

SQL Navigator for Oracle 8.1 - User Guide

Quick Overview Working With SQL Navigator Navigation Oracle Logon Code Editor Visual Object Editors Team Coding and Version Control Systems Modules, Windows And Dialogs
Analyze Tool Auto Describe Tool Benchmark Factory Bookmarks Dialog Capture Web Output Change Logon Password Dialog Code Analysis Code Assistant Code Road Map Code Templates Code Test Database Source Code Search Dialog DB Navigator Describe Difference Viewer Edit Data ER Diagram Explain Plan Tool Export Table Find and Replace Dialog Find objects Dialog Find Recycle Bin Objects Dialog Formatting Options HTML Viewer Import HTML as PL/SQL Import Table Java Manager Job Scheduler Locate In Tree Output Window PL/SQL Profiler Profile Manager Project Manager Publish Java to PL/SQL Quick Browse Rename Object Search Knowledge Xpert Select DB Object Dialog Server Output Server Side Installation Wizard Session Browser Source Preview SQL Modeler SQL Optimizer Task Manager Web Support Configuration Dialog Wrap Code
View | Preferences About Us

Criteria

  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

Generated Query

This tab lists the automatically generated SQL statement.

Note:

  • Any changes made to the Model Area or Criteria Tab will automatically regenerate this SQL statement.
  • You cannot directly edit the SQL on the Generated Query tab.

 

Right-click over the query

Menu Description

Copy

Copy the query to the clipboard.

Save As

Save the query to a file.

View Query in Code Editor

Copy the query directly to the Code Editor.

Query Results

Show the results of executing the generated query.

Note:

  • Insert, Update, and Delete queries can only be executed in the Code Editor.
  • Making changes to the Tables or Columns, then clicking on the Query Results tab will prompt you whether or not to re-query the data.

SQL Optimizer

SQL Optimizer supplements Oracle tuning skills for developers. The SQL Optimizer makes observations about a selected SQL statement and the underlying database environment, then recommends several options to improve performance. Users can then view the logic behind the advice, implement the recommendation, apply it to the database, and see the results. The SQL Optimizer module automatically produces all necessary SQL to effect the corresponding change.

Note:

  • SQL Optimizer can be used to analyze the execution of SQL scripts containing more than one statement.
  • SQL Optimizer is an external application. It is installed independently of SQL Navigator.
  • Example Scenario: in the Code Editor highlight the text of the SQL statement you want to investigate and click SQL Optimizer.
  • For more details, see the online help supplied with the SQL Optimizer product.
関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択