Option | Description | ||||||
---|---|---|---|---|---|---|---|
Allow multi Code Editor windows per Session |
Related To: Code Editor.
| ||||||
Show Logon Dialog startup |
Select to show the Oracle Logon Dialog when you launch SQL Navigator. | ||||||
Show code editor after connection |
| ||||||
Default date format |
Select the default date format, for example, MM/DD/YYYY. Used when a date-to-string conversion request is explicitly made; for example, in SELECT TO_CHAR(SYSDATE) FROM DUAL. Otherwise a binary format is used for date/time handling. On screen date/time representation is made using the client machine’s Regional Settings (set in the Windows Control Panel).
| ||||||
DBMS Output On by default |
Related To: Server Output.
| ||||||
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.
| ||||||
Close when last session window closes |
| ||||||
Show Users in Schema Lists |
Related To:
| ||||||
Retrieve large numbers as strings |
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:
| ||||||
Show All Constraints |
Related To: DB Navigator
| ||||||
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.
| ||||||
Retrieve tablespace usage info |
Select to add the following columns to the tablespace details pane:
| ||||||
National Language Support (To make this option changes effective right away, shut down SQL Navigator then restart) |
| ||||||
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
| ||||||
Keep existing sessions alive |
|
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. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center