Connecting to the Oracle Database

 

 

Oracle Logon

 

 

image\Sqln0207.gif

 

 


Click the drop-down button to pick from a list of available database connections.

 

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.

 

 

 

 

image\Sqln0011.gif

 

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.image\Sqln0001.gif

Alternatively, you can click the New Session icon to open a new one. image\Sqln0001.gif

image\Sqln0005.gif

 

 

 

image\Sqln0002_wmf.gif

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.

image\Sqln0003.gif

 

 

 

The workspace window can include connection shortcuts

For more information see:

image\Sqln0004.gif To open a connection in the workspace

image\Sqln0004.gif To add an object or file to the current workspace