Discover the easiest way to Install SQL Developer in Windows with our detailed guide. Each step includes screenshots to help you through the installation. Let’s get started!
Table of Contents
1. Download SQL Developer on Windows from the following link. First, select the platform Windows 64-bit with JDK 11 included and click on the Download button:
2. Accept the Oracle License Agreement and download the software:
3. Go to the downloaded location:
4. Right-click on the downloaded zip file and extract the file:
5. Once extracted, Go into the installation folder and run the file sqldeveloper.exe to install Oracle SQL developer:
6. Now we have to connect the database through the SQL Developer. First, check the TNS details of the database:
From the above, we can find the HOST, PORT, and SERVICE_NAME. Now we will use these details to connect to the oradb database:
7. In sqlplus developer, create a new connection and provide any connection name. Now provide the username, password, and the details that we have found from tnsping.
In the Hostname you can provide the IP address also. If you are connecting with the SYS user then change the Role from default to SYSDBA.
8. Now you can issue any SQL statements to the database. Select the SQL statement (using the keyboard, move the cursor to the statement) and click on the Run button or the shortcut [Ctrl]+[Enter].
You will see the output of the statement in the Query Result panel. If you want to execute more than one statement at the same time, you have to select them and press the run button or shortcut key to execute the statements. If you want to execute all the statements in the working panel as a script then press F5 function key. In this case, the output appears in the Script Output panel.
Congratulations! Installing SQL developer on Windows is completed successfully. I hope you found this article helpful. Feel free to reach out if you have any questions. If you want to install client software like Putty or MobaXterm, You can follow my articles: