Option	Description
Style	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

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

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.

Startup

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.

Selected

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

Selected

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 All Schemas node in DB Navigator.
The Current Schema drop-down list in the Object toolbar (Toolbars).
The drop-down lists in the editing windows.

Selected	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:

Will be left-aligned in windows and dialogs
Will be sorted alphabetically rather than numerically in sorted lists
Cannot be used with SQL Navigator calendar functions

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:

size_mb – the allocated size of the tablespace in megabytes
used_mb – the number of megabytes currently used by the tablespace
used_percent – the percentage of the tablespace currently used.

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.

Trace

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.

Documentos relacionados

The document was helpful.

Selecione a classificação

I easily found the information I needed.