Oracle Developer Tools for VS Code (SQL and PLSQL)
This extension enables editing and execution of SQL and PL/SQL for Oracle Database and Oracle Autonomous Database.
View the Quickstart: Get Started with Oracle and VSCode for details on how to configure, connect and use Oracle Developer Tools for VS Code. Questions or feedback about this extension? Please post your questions or comments on the Oracle Developer Tools forum.
Connect using hostname/port/service name, TNS alias, Easy Connect connection string, connect descriptor, directory server (LDAP) service name, or ODP.NET connection string. Other options include connecting with a proxy user and setting the current schema.
Create and Manage Oracle Autonomous Databases
Create and manage Oracle Autonomous Databases (ADBs) using the Oracle Cloud Infrastructure Explorer tree control. Create new Always Free or paid ADB instances, and start, stop, and terminate existing ADB instances. Automatically download credentials files and create a database connection.
Oracle Database Explorer
Explore your database schema in a tree control. Right click on the connection name to open an existing SQL file or create a new file that uses that connection. Show table data and generate CREATE, INSERT, or DELETE SQL for tables. View, edit and run stored procedures and functions. Explore other users' schemas.
View table data and save as CSV or JSON
View the results of queries in a grid and save the results in CSV or JSON format.
Navigate through scripts using breadcrumbs
Use breadcrumbs to easily navigate through large scripts.
Problems panel integration
Errors encountered when running SQL scripts or when saving PL/SQL to the database are placed in the Problems panel. Clicking on the error takes you to the line in the script where the error occurred.
Autocomplete and intellisense for schema objects
Begin typing SQL and autocomplete suggestions will appear. Enter a schema name or schema object name followed by a period (".") to use intellisense to show the child objects. Modify the settings to choose whether to use upper or lower case.
In the examples below, a stored procedure will autocomplete as you type - or you can choose to fill in a template for the call:
Code snippets provide example templates for various SQL commands. They are shown when you type 'oracle':
Test stored procedures and functions
Use the Oracle Database Explorer "Run" menu item to run a procedure or function, enter input parameters and view output parameters. If the output parameter is a cursor, you can fetch and display the results.
Bookmarks and history
Save SQL and PL/SQL as "bookmarks" which can later be executed or added to SQL scripts. SQL history is stored for a Visual Studio Code session and can be run, added to scripts, and/or saved as a bookmark.
Changes in version 21.3.0
Please refer to the Licensing Information User Manual for Oracle Developer Tools for VS Code for additional licensing information including third-party notices and/or licenses.
Copyright (c) 2021, Oracle and/or its affiliates.