Sql Developer

Oracle SQL Developer is a free graphical tool provided by Oracle that enhances productivity and simplifies database development tasks. Using SQL Developer, you can browse database objects, run SQL statements, edit and debug PL/SQL statements and run reports, whether provided or created.

Developed in Java, SQL Developer runs on Windows, Linux and the Mac OS X. This is a great advantage to the increasing number of developers using alternative platforms. Multiple platform support also means that users can install SQL Developer on the Database Server and connect remotely from their desktops, thus avoiding client server network traffic.

Default connectivity to the database is through the JDBC Thin driver, so no Oracle Home is required. To install SQL Developer simply unzip the downloaded file. With SQL Developer you can connect to any supported Oracle Database.

Before starting, you should:

1 .Install Oracle SQL Developer 3.0 from OTN. Follow the read me instructions here.

2 .Install Oracle Database 11g with the Sample schema.

3.Unlock the HR user. Login to SQL Developer as the SYS user and execute the following command:

alter user hr identified by hr account unlock;

4 .Download and unzip the files.zip to a local folder on your file system. In this tutorial, we use the C:\sqldev3.0 folder.

Creating a Database Connection

The first step to managing database objects using Oracle SQL Developer 3.0 is to create a database connection. Perform the following steps:

1 .If you installed the SQL Developer icon on your desktop, click the icon to start your SQL Developer and move to Step 4. If you do not have the icon located on your desktop, perform the following steps to create a shortcut to launch SQL Developer 3.0 directly from your desktop.

Open the directory where the SQL Developer 3.0 is located, right-click sqldeveloper.exe (on Windows) or sqldeveloper.sh (on Linux) and select Send to > Desktop (create shortcut). 

2 . On the desktop, you will find an icon named Shortcut to sqldeveloper.exe. Double-click the icon to open SQL Developer 3.0.

Note: To rename it, select the icon and then press F2 and enter a new name.

3 .Your Oracle SQL Developer opens.

4 .In the Connections navigator, right-click Connections and select New Connection.

5 .The New / Select Database Connection dialog opens. Enter the connection details as follows and click Test.
Connection Name: HR_ORCL
User Name: hr
Password: (Select the Save Password checkbox)
Hostname: localhost

6 .Check for the status of the connection on the left-bottom side (above the Help button). It should read Success. Click Connect. Then click Save.

7 .The connection was saved and you see the newly created connection in the Connections list.

8 .Expand HR_ORCL.

Note: When a connection is opened, a SQL Worksheet is opened automatically. The SQL Worksheet allows you to execute SQL against the connection you have opened.

9 .Expand Tables.

10 .Select the EMPLOYEES table to view the table definition. Then click the Data tab.

11 .The data in the table is shown. In the next topic, you create a new table and populate the table with data.

12 .Click the DEPARTMENTS table in the Connections navigator.

13 .There are a number of constraints for the DEPARTMENTS table. To view the various constraints on the table, click the Constraints tab.

14 .Note that the DEPARTMENTS table has 4 constraints. Each constraint has a unique name. The CONSTRAINT_TYPE identifies the type of constraint on the table.

Click Edit

15 .The Edit Table dialog has a number of fields. Select Foreign Keys beneath the Search field.

16 .Review the Foreign Keys constraints. Note that the DEPARTMENTS table has two foreign keys, one named DEPT_LOC_FK and the other named DEPT_MGR_FK. When you select one of the names in the Foreign Keys field, the details about that foreign key appear.

Click OK to leave the Edit Table dialog.

To Know more about SQL Developer Please visit: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/sqldev3.0_GS/sqldev3.0_GS.htm

Please share your views about this Article.


  1. Hey very nice blog!!
    Hi there,I enjoy reading through your article post, I wanted to write a little comment to support you and wish you a good

    continuationAll the best for all your blogging efforts.
    Appreciate the recommendation! Let me try it out.
    Keep working ,great job!

    1. Hi Friend,

      Thanks for you appreciation.