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 for selected text
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
PL/SQL: Normalize local prefixes: Converts all nonstandard v_ prefixes to l_ prefixes.
SQL Formatting:
SQL: Remove Quotes from Identifiers: Removes the quotes from quoted identifiers
SQL: Cleanup Cart Export: Formats the export of an Oracle SQL Developer cart to a more readable format.
SQL: Normalize comma placements to move commas found at the beginning of lines to the end of the previous line.
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.
IntelliSense based on the database objects:
Option to connect the workspace to an Oracle database
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.
