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.

Version 21.4.0

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.

Features include:

• Connect to Oracle Database and Oracle Autonomous Database using Easy Connect syntax, TNS connect aliases, or ODP.NET connection strings
• Create and manage Oracle Autonomous Databases (ADBs) using Oracle Cloud Infrastructure Explorer tree control. Create, start, stop and terminate ADB instances. Automatically download credentials files and create a database connection.
• Oracle Database Explorer tree control: connect and explore Oracle schemas; show data for tables and views and save as CSV or JSON files; auto-generate CREATE, SELECT, INSERT, and DELETE statements for tables; view, edit, debug and save PL/SQL packages, procedures and functions. Run stored procedures and functions with a UI for entering parameter values.
• Edit SQL and PL/SQL with support for hovering, Go to/Peek Definition, Go to/Peek Type Definition and Go to/Peek Implementation. The editor also features IntelliSense for autocompletion of schema object names, procedure/function parameters, and SQL*Plus commands. Navigate through large scripts using breadcrumbs.
• Debug PL/SQL in stored procedures, functions, and packages using Visual Studio Code's native debugging features. Compile PL/SQL for debugging, step into PL/SQL, and run to a breakpoint. Enable External Application Debugging to listen for and debug PL/SQL procedures and functions called by applications or SQL scripts.
• Execute SQL and PL/SQL and view and save results. View errors in the Problems panel and navigate to the line with the error. Enter bind and substitution variables into a dialog.
• Limited SQL*Plus support
• View SQL command history and view and save SQL bookmarks

Feature Highlights

Connection Dialog

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, SELECT, INSERT, or DELETE SQL for tables. View, edit, debug and run stored procedures and functions. Explore other users' schemas.

PL/SQL debugger

Debug PL/SQL in stored procedures, functions, and packages using Visual Studio Code's native debugging features. Compile PL/SQL for debugging, step into PL/SQL, and run to a breakpoint. Enable External Application Debugging to listen for and debug PL/SQL procedures and functions called by applications or SQL scripts.

Use IntelliSense to autocomplete schema objects

Begin typing SQL into the editor and autocomplete suggestions will appear. Enter a schema name, schema object name, or alias followed by a period (".") to show the child objects. Enter a stored procedure or function name and autocomplete the parameter list. 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:

Navigate SQL and PL/SQL code with Hover, Go to, and Peek

Use powerful editor features to navigate and learn more about SQL and PL/SQL objects. The editor supports hovering, Go to/Peek Definition, Go to/Peek Type Definition and Go to/Peek Implementation.

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.

Code snippets

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.4.0

• PL/SQL Debugger - Debug PL/SQL in stored procedures, functions and packages using Visual Studio Code's native debugging features. Use menus to compile PL/SQL for debugging, to step into PL/SQL, and to run to a breakpoint. Enable External Application Debugging to listen for and debug PL/SQL procedures and functions called by applications or SQL scripts.
• IntelliSense support for table/view aliases
• Smarter IntelliSense: Continuous parsing of SQL fragments being typed enables much better context sensitive autocomplete suggestions
• Editor now supports hover, Go to/Peek Definition, Go to/Peek Type Definition and Go to/Peek Implementation
• Generate Create SQL menu item in Database Explorer outputs a CREATE SQL statement for a table or view
• Support for User Defined Types within a select list (for example, queries against tables that include Oracle Spatial types)
• SQL Parameter Binding Dialog is displayed with a request for input values when SQL is executed that includes undefined bind and substitution variables
• Procedure/Function input parameter dialog improvements including keyboard only entry (no mouse clicks required)
• Support for TLS based database connections without a wallet
• Support for single sign-on (SSO) with OCI IAM when connecting to Oracle Autonomous Database
• PL/SQL Compiler Settings page
• Support for .NET 6 which enables ARM64 processors such as Apple Silicon

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) 2022, Oracle and/or its affiliates.