

Then you can check in the corresponding SQL scripts into source control alongside your application code. With Oracle Developer Tools for VS Code, you can edit stored procedures and functions and test them. Many Oracle Developers use Visual Studio Code for writing Python, Java, or C# apps that access the database, calling PL/SQL stored procedures or functions from within their code. As Visual Studio Code runs on Linux, macOS and Windows, this extension can be used by any Oracle developer.

In earlier blog posts, I’ve introduced Oracle Developer Tools for VS Code, Oracle’s free extension for Visual Studio Code that enables editing and execution of SQL and PL/SQL (and much more) with Oracle Database and Oracle Autonomous Database. Debugging PL/SQL from inside Visual Studio Code
