The Rhenium extension for Visual Studio Code enhances your development experience with Oracle SQL and PL/SQL. Many features are available in the command palette or the Rhenium context menu after selecting text.
Features
PL/SQL Formatting
PL/SQL Align: Aligns the selected code on := and => for better readability. You can select multiple blocks at once. Ctrl+Alt+A
PL/SQL to lowercase: Converts the selected SQL or PL/SQL code to lowercase without changing strings and comments. Ctrl+Alt+L
PL/SQL to uppercase: Converts the selected SQL or PL/SQL code to uppercase without changing strings and comments. Ctrl+Alt+U
JSON to PL/SQL
JSON to JSON_OBJECT/ARRAY: Converts the selected JSON data to PL/SQL JSON_OBJECT or JSON_ARRAY.
JSON to JSON_TABLE: Converts the selected JSON data to PL/SQL JSON_TABLE in the selected text.
PCK_TS_LOG to PCK_LOG_RS: Replaces occurrences of PCK_TS_LOG with PCK_LOG_RS in the selected text.
Option to connect the workspace to an Oracle database
IntelliSense based on the database objects:
Package completion for public package methods available in the connected schema. (Experimental)
Usage: Type the first part of the package name and use Ctrl+space to get the available packages.
Method completion for public package methods available in the connected schema. (Experimental)
Usage: Type the package name followed by a dot. Then the list of available methods should appear. Select the method and the code to call the method is added.
Note: In the future, there will be an offline version based on the workspace files. The online version will then only be used for calling packages not available as workspace files, such as DBMS_* and APEX_*.
IntelliSense based on the workspace files:
Hover info for package methods.
Usage: Hover over a method to get the declaration and PL/Doc info if available.
Definition navigation for package methods.
Usage: Ctrl+click on a method to navigate, or use F12 or the 'Go to definition' option in the context menu.
Declaration navigation for public package methods. (Private declarations are not yet supported).
Usage: use 'Go to declaration' option in the context menu.
More info
Select Rhenium: Show Docs from the Command Palette.