Monday, August 18, 2025

SQL Developer Extension for VS Code


Hi, Recently i came across a new wonderful feature introduced by oracle “Oracle SQL Developer for VS Code”, Yes oracle in early 2024 released an extension for VS Code where it provides the ability to execute your SQL queries and scripts and perform PL/SQL development and its pretty awesome and here is how you can install


Download Visual Studio Code (VS code) in case if you dont have it from here

Oracle Database versions supported to use this extension : 11g to 23


To install click on “Extension” on Left side icon


Search for ‘Oracle’ and install the extension as shown below



DB connection setup


Once installed a new ICON is shown like below






From the Connection type choose “TNS” and locate the TNS file in case if you want to use TNS entries


Go to “file” → “Preferences” → “Settings” → “Database Connections” 


And update the path of the TNS file of your 


If you encounter any issue using TNS connection then use “Connect Identifier” option in Type and use the TNS alias name in "Connect identifier"



Once you setup DB connection then you can browse all DB objects in Tree Navigation and run select queries against the DB

Read More:

https://www.oracle.com/database/sqldeveloper/vscode/

https://marketplace.visualstudio.com/items?itemName=Oracle.sql-developer






0 comments:

Post a Comment

Auto Scroll Stop Scroll