Online Documentation for SQL Manager for Oracle
The Options section of the Database Registration Info dialog allows you to set various options for the database.
Customize common database options according to your needs. The detailed description is given below.
Login prompt before connection
Autoconnect at startup
Check this option to specify that SQL Manager for Oracle automatically establishes connection to the registered database at application startup.
Refresh objects on connection
This option allows you to enable/disable refreshing objects on connection to the database. It is highly recommended to uncheck this option if your database contains many objects or if connection to the database is slow.
Creates a trace log file at the client side which allows you to view statistics data on sessions, connections, etc.
When checked, transactions are committed automatically.
Hide empty schemas
This option allows you to specify whether schemas containing no objects will be displayed in the DB Explorer tree.
Convert created objects' names to upper case
Enable this option if you need to convert the names of all newly created objects to the upper case automatically.
Show storage parameters
With this option enabled storage parameters for objects are displayed in DDL.
Define the separator which will be used for floating point type values. Possible separators are: dot ("."), comma (",").
This option allows you to hide schemas and disable refreshing their objects. Select the schemas for displaying in DB Explorer. Note that the current and PUBLIC schemas are allowed by default and cannot be restricted.