Oracle SQL Developer Extension for VSCode

Happy Friday! LinkedInFam

Today I will be showing a set of screenshots and why you should be using VSCode as your SQL Query Development.

1) Launch VSCode

2) Navigate to the Extensions tab and search for Oracle SQL Developer Extension for VSCode

3) Now click on the Install button to install the extension

4) Now once it is ready, navigate to the Database icon on the bottom left of the extensions and click Create Connection button.

5) Now in the Connection Dialog, make sure you add your Database connection info. Here I am using an ADB Serverless instance and a Cloud Wallet for my connection. Your connection settings may differ.

Please consult your Oracle DBA for connection information.

Test the connection and click on Save and Connect.

6) Now Right Click on the Database icon and choose Open SQL Worksheet

7) Now enter a command like

select name,
       open_mode,
       created
  from v$database;         

8) The output should return your database name, open mode , either READ, READ WRITE, and when it was Created

9) Now you can also appreciate the IntelliSense built into this extension

Congrats! you are now ready to start working with Oracle Databases within VSCode.

Happy coding!