Oracle SQL Developer Installation and configuration
Oracle SQL Developer Tool Installation and configuration.
Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle.
Below are the steps to Download, Install and Configuration of SQL Developer.
Step 1: In chrome, type “ download sql developer”
Step 2: Choose the highlighted file to download
Step 3: Select the checkbox and click on download.
Step 4 : Progress of the percentage download.
Step 5: Go to Downloaded path and click on setup.exe
Step 6: You will get below screen.
Step 7: Click on Plus symbol in the left most corner from the above screen to start the connectivity test.
Below details are required:
- DB Username
- DB Password
- DB Server name (in this case local host)
- Port number (1521 is a default number)
- SID (MKTG)
Then you click on the TEST button.
And you can see the status: Success as highlighted in the below picture.
Step 8: Click on save and connect Button.
Step 9: Run the below queries in the sql worksheet as highlighted.
- Select * from dual;
- Create table emp (name varchar2(20));
- Select * from user_objects;
For testing the above queries first do highlight the each query and click on green play button
See Also: