Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Auto connect to database when working on multiple files

Kevin ZhangApr 11 2024

here is my typical project workflow:

I am having a folder called “Source Code” and it contains many SQL or PLSQL scripts. All these scripts has extension “*.sql”. I am using Windows 10. I typically select “Source Code” folder and right mouse click and choose “Open with Code”. Then VS Code is launched; then I start making changes to my SQL or PLSQL scripts. when I open any script, it is always “No connection attached” so I have to manual choose a DB connection for each of this file. Typically, I am working on 20+ scripts and I have to manually choose a database connection 20+ times.

Expected feature: when I right mouse click “Source Code” folder and choose “Open with Code”, VS code should be launched and it should show a pup up dialog and ask me “pick a default database connection” so I don't have to manually select a db connection later for each individual script.

Thanks!

Kevin

Comments
Post Details
Added on Apr 11 2024
5 comments
383 views