Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - 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

General | User Interface

| User Interface

Set SQL Navigator preferences.

User Interface

Option Description


Select the look and feel of SQL Navigator windows from the following styles:

  • Standard
  • Flat
  • XP
  • Native (the default style)
  • Office 2003
Tutorial Messages Select to display tutorial messages automatically for windows. First-time users may find these messages especially helpful.
Hints Select to show Tool Tips. Tool Tips are labels that pop up when you point to a button or other control.
Font Select the font to use in SQL Navigator windows.
Date Displayed Format Select the preferred layout for showing dates.
Time Displayed Format Select the preferred layout for showing the time.
Display time in DATE fields Should DATE fields include the time?

Bold Folders in DB Navigator Tree

Select to show folders as bold in the DB Navigator tree. Showing the folders as bold may help clarify the structure of a complex tree.

Used by: DB Navigator.

Default Directory

The default directory SQL Navigator points to for Open and Save operations.

Used by: File Menu, Toolbars, Code Editor, HTML Viewer.

Background Color The color of the background area.

Data Grid

Related to: Code Editor | SQL Query Results Data Grid, Edit Data, Quick Browse

Option Description
Show Row # Select to show row numbers in the data grid.

Display Long columns

Select the display for LONG columns.

On demand (in pop-up editor)

Data in a LONG column is displayed in a separate pop-up editor.

For each cell:

The word "MEMO" in upper case

Indicates the cell has data. Double-click the word to display the data in a pop-up editor.

The word "memo" in lower case Indicates there is no data to display.

Full text (within cells)

Columns are effectively treated like normal string (VARCHAR2) columns, that is, data is displayed within the corresponding cells as a single string.

Trim column width while pasting

When an object is copied from the Code Editor or one of the Visual Object Editors and pasted to another tool, for example Note Pad...

Selected The length of each pasted column is trimmed to approximately the length of the longest character string in the column.
Not Selected The pasted data reflects the actual length of the column as defined in the object.

Display NULL values as (Null)

Selected Show Null values as "(Null)" in the data grid.
Not Selected Show Null values as empty cells in the data grid.
Data Grid Font The font used in the data grid result set.
Show Row Background Color Set up an alternate row color in the data grid.

Pin at Start

Option Tool Description
Analyze Analyze Tool
Selected The window is pinned. Open multiple instances of the tool at the same time.
Not Selected The window is not pinned. If you reopen the tool, the newly opened instance of the tool will replace the current instance.

Note: Once a window of the selected type is open, you can pin or unpin it at any time.

Describe Describe
Explain Plan Explain Plan Tool
Object Editors Visual Object Editors

Automatically Show Output Window

Related To: Output Window.

Option Description
Errors Show the Output window automatically when errors are sent to it.
Server Output Show the Output window automatically when server output is sent to it.
Information Show the Output window automatically when informational text is sent to it.


Option Description
Show Splash screen Select to show the Splash screen when you launch SQL Navigator.
Reopen active windows Select to show all active windows from the last time SQL Navigator was used.
Show Welcome Screen Select to show the welcome screen when you launch SQL Navigator.

ER Diagrammer

Related To: ER Diagram.

Option Description
Show real index names Show real index name instead of the one generated by the system.

Task Manager

Related To: Task Manager.

Option Description
Auto delete complete&more-than-one-day tasks Remove completed tasks, and still running tasks that started more than one day ago.

Connection Category Color

Related To: Connection Category Color.

Option Description
Connection Color for Taskbar When selected the Connection Category Color for the Task Bar is displayed.
Connection Color for Forms When selected the Connection Category Color for forms is displayed.
Connection Color for Code Editor Tabs When selected the Connection Category Color for the Code Editor is displayed.

General | "Drop" and "Truncate" safety options

| "Drop" and "Truncate" safety options

Drop and Truncate

Related to: Object Menu | Drop and Object Menu | Truncate.

Option Description
No "Drop" or "Truncate" for Table/Cluster Select to disable the Delete option for table and cluster objects.
No "Drop" for Stored Programs/Triggers Select to disable the Drop command for stored programs and triggers.

General | Session

| User Interface | Date Displayed Format.

DBMS Output On by default

Related To: Server Output.

Selected Server Output is switched on, on connecting to the database.
Not Selected Server Output is switched off, on connecting to the database.

DBMS Output buffer (bytes)

Change the buffer size for server output. Set the desired upper limit for the DBMS Output Buffer (Bytes).

Related To: Output Window.

Cache Capacity

The number of database objects that can be placed in the cache before the cache refreshes itself and accesses the database.

Optimizer Goal/Mode

The approach the Oracle optimizer uses to optimize a SQL statement. For more information, see the ORACLE 7 SERVER Concepts Manual.

Immediate load in Open Object Dialog

Related To: Select DB Object Dialog.


SQL Navigator automatically builds a pick-list of all available database objects.

Not Selected

Specify selection parameters before loading the pick list of database objects.

This saves time and resources.

Close when last session window closes


SQL Navigator terminates a session when all session windows are closed.

SQL Navigator prompts you before terminating the session, unless you have disabled the prompt previously.

Not Selected

A session can still be active when all its windows are closed.

Show Users in Schema Lists

Related To:


The lists of schemas will be populated with Users—regardless of whether those users own any objects.

Not Selected

The schema lists will include only users with objects.

Retrieve large numbers as strings

Selected Numeric fields from the database with a precision exceeding 15 digits will be converted to strings on the server.
Not Selected These numbers will be represented in scientific notation.

The advantage of converting large numbers to strings rather than displaying them in scientific notation is to avoid loss of precision in screen displays and reports. However, note that converting numbers to strings means that they:

Note: The related View | Preferences |Code Editor | SQL Scripts | Retrieve all result fields as strings overrides this preference.

Show All Constraints

Related To: DB Navigator

Selected Show system-defined constraint names for NOT NULL attributes.
Not Selected Exclude system-defined constraint names.

Bytes per character

The number of bytes to allocate per character. If you select Autodetect then SQL Navigator attempts to determine the actual number of bytes per character while establishing connection.

Note: You can override this preference for specific connections from the Oracle Logon Dialog. If you receive ORA-01026 errors (or similar) when working with the database, we recommend setting this preference to the minimum possible value (2, 3 or 4) that eliminates the errors.

Retrieve tablespace usage info

Select to add the following columns to the tablespace details pane:

Note: Available only for users with access to DBA views. For more information, see DBA Dictionary Views.

National Language Support (To make this option changes effective right away, shut down SQL Navigator then restart)

No Support NLS is not supported by default.
Display and Edit multi-byte data Display and enter data in the Code Editor Data Grid (SQL Query Results Data Grid) in any language supported by Windows. This option is not applicable with the column or object names. However, multiple languages can be displayed without making any changes to the system environment.

Read Buffer Size

The number of records SQL Navigator reads per database request.

Use user's dictionary views

This preference is specific to background queries to list objects and to get object details for the logged in user’s schema

Selected SQL Navigator uses USER views to query the Oracle Data Dictionary.
Not Selected SQL Navigator uses ALL or DBA views to query the Oracle Data Dictionary, dependent on the value of Enable DBA Views in the Oracle Logon Dialog.

Keep existing sessions alive

Option Description
Issuing 'select * from dual' every interval (minutes)  

Auto run script at connect

Option Description
Auto run script at connect Run the named script on connecting to the database.
Close script on successful execution Select for the named script to close automatically when it has finished running.


Option Description
Enable Select to log all transactions with the database to a file. This is useful for debugging purposes.
Level Select the type of messages the trace file will record.

General | Default Tables

| Default Tables

Default Tables

Option Description
Exception Table Owner Name of the schema where the exception table is to be stored.
Exception Table Name of the exception table.
Chained Rows Table Owner Name of the schema where the chained rows are to be stored.
Chained Rows Table Name of the chained rows table.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating