ß
Click the drop-down button to pick from a list of available database connections.
Oracle Logon
|
|
ß |
When you start SQL Navigator, or invoke the New Session command, the Oracle Logon dialog (shown above) prompts you for connection information. You can click the drop-down button in the Database box for a list of available database connections.
|
|
|
|
|
|
|
|
The Logon dialog on startup is controlled by a Preferences option. Click here for more information.
|
Automatically saving passwords
The Oracle Logon dialog gives you the option of saving a password for each username/database combination.
Your password is saved in encrypted format, and then recalled automatically when you next enter the same username/database combination.
The username field automatically recalls user name/passwords combinations based on the first letter(s) entered into the field.
Creating a session
When you first start up SQL Navigator, you create a database connection. You can set up multiple sessions with one database, or with many databases. Each database connection is known as an "Oracle instance".
The most recently used connection shows as the default connection. SQL Navigator saves the connection profiles you enter to a list of connections.
Each session-related window (code editor, object editor, and so on) remembers and automatically opens in the appropriate database session.
In this version of SQL Navigator, you can freely switch to other sessions and continue working within the same window.
To activate another window for another session, select the other window from the Task Bar or switch sessions, and then click a button or menu item to open a new window.
To switch sessions or create a new session
|
Use the drop-down list on the Session Toolbar to switch sessions. Alternatively, you can click the New Session icon to open a new one. |
|
Automatically saving passwords
The Logon dialog lets you save a password for each username/database combination.
Your password is saved in encrypted format, and then recalled automatically when you next enter the same username/database combination.
The username field automatically recalls user name/passwords combinations based on the first letter(s) entered into the field.
Fast access to connections stored in your Workspace
You can save connection shortcuts (username/connection strings) in your workspace(s) and then simply double-click to open them. You can also store shortcuts to objects in the workspace. When you double-click their icons, they will automatically open the required connection.
|
|
ß The workspace window can include connection shortcuts |
For more information see:
To open a connection in the workspace
To add an object or file to the current workspace
