General | User Interface
| User Interface
Set SQL Navigator preferences.
User Interface
| Option | Description |
|---|---|
|
Style |
Select the look and feel of SQL Navigator windows from the following styles:
|
| 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.
| ||||||||
|
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...
| ||||||||
|
Display NULL values as (Null) |
| ||||||||
| 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 |
| ||||||
| 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. |
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 optionsDrop 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. |