Oracle SQL Developer is GUI tool which gives you Interface in which you can run sql commands and perform oracle operations without writing sql scripts.
Before installing Oracle SQL Developer you must check whether Java development kit (JDK) is already installed on your system, If it is not installed then please installed. (Please note it is Java SE Development Kit 6u33, since I am doing it on Windows 7 64 bit I have choose jdk-6u33-windows-x64.exe)
Download and install 64-bit Java 6 JDK
Installing Java Development Kit (JDK). Click \"Next\"
Click \"Next\"
Please wait while installation is complete.
Click on \"Finish\" button to complete JDK Installation
Ones you have downloaded Oracle SQL Developer as mentioned in step 1, now extract the zip file and rename the folder \"sqldeveloper\" to \"OracleSQLDev\" (Renaming folder is not required but I will recommend doing that to avoid confusing folder name)
Copy \"OracleSQLDev\" folder to your C Drive [C:] for easy access.
Goto C:\OracleSQLDev
Double click on \"sqldeveloper.exe\"
Enter the full pathname for java.exe in prompt dialog box. (Please Note: Path of JDK - Java.exe and NOT java runtime java.exe)
Path for Java.exe - C:\Program Files\Java\jdk1.6.0_33\bin\Java.exe (This path may be different based on your installation)
That\'s it you are done.
Now let\'s configure Oracle SQL Developer.
File > New > Database Connection
-OR-
Select New Connection by expanding little plus sign as shown in figure.
In New database connection dialog box enter information as explained under.
Connection Name: You can choose any, since we have installed a sample HR schema which we are trying to connect, I will be using name \"HR Schema\"
Username: HR, since username for HR schema is \"HR\"
Password: Enter password as you have choose for HR schema while creating HR Schema.
Check Save Password
Let the default settings unchanged as shown in figure and click on Test button, it will show Status: Success
Now Press \"Connect\" button
You can now notice that left pane of Oracle SQL Developer has filled with tables, views, etc. You can expand each of them and perform operation right inside this tool.
You will also noticed that running queries is also user friendly.
Type the query
Select * from employees
And hit \"F9\" key
That\'s it you are all set to explore oracle.