SQL Developer - The Universal Database Frontend


SQL Developer in a Nutshell

This section shows screenshots of SQL Developer accompanied by an extract of the user manual. The full user manual can be dowloaded here. Click on a screenshot to enlarge it to its original size.



The desktop of the application consists of the following components:

1. Main menu and tool bar

2. Database Navigator

3. Output window and Bookmarks

4. MDI (Multiple Document Interface) window area

5. Context menus

Some components (Database Navigator, output window and bookmarks) can be individually positioned on the desktop by the user. Click on the tab of the component to move and drag the component to its new target position.

Connection Dialog


Use the connection dialog to open a connection to a database.

For each new connection SQL Developer creates a profile that is displayed in the dropdown list in the upper part of the dialog. When the user selects a stored profile the connector described by the profile gets selected and its fields are preset.

To create a new connection select a suitable connector first. All available connectors are displayed as tabs. Except for the Basic connector the required drivers for a connector are predefined.

Press the Info button to show the information about the driver (name, driver class, vendor, URL and status). If a required driver for the selected connector is not available this is shown by the status field.

You can add missing drivers directly from the connection dialog. Use the Driver Settings button to add a new driver. The opening dialog shows the Drivers tab of the Settings dialog.

After you have specified the parameters for the selected connector you can create a new connection by pressing the OK button.

Tip See the tutorial on creating your first connection to an ORACLE database

Configuring Database Drivers


To access a database SQL Developer must have a suitable JDBC driver installed. Usually JDBC drivers for a database can be downloaded from the internet site of the database vendor for free. In most cases the driver files have the extender JAR (Java Archive) or ZIP (mainly older drivers).

Select the Settings item from the Extras menu. Click on the Drivers tab.

This tab shows all drivers currently available. With the Add button you can open the file selection dialog for driver files. Select the previously downloaded driver and confirm with OK.

Now the driver is shown in the tree and can be used.