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