Oracle Apex Autocomplete

Oracle APEX Autocomplete adds smart code completion to Oracle APEX Monaco editors.

Features:

SQL Autocomplete
Keywords, clauses, and common SQL syntax as you type.

PL/SQL Autocomplete
PL/SQL keywords, built-in functions, procedural constructs, and snippets.

Oracle APEX API Autocomplete
Public Oracle APEX PL/SQL APIs with package and member suggestions
(APEX_UTIL, APEX_PAGE, APEX_APPLICATION, APEX_JSON, APEX_MAIL, and more).

Parameter Hints
Signature help for Oracle APEX APIs and locally declared routines while typing function and procedure calls.

Code Formatting (Beta)
SQL and PL/SQL formatting with indentation support.

Configurable Keyword Case
Choose whether completions, parameter hints, and formatting use uppercase or lowercase keywords.

Language Switching
Switch Monaco editors between SQL and PL/SQL modes.

Variable Detection
Recognizes declared variables in your current code and includes them in suggestions.

Local Code Autocomplete
Detects locally declared packages, procedures, and functions in the current editor, and adds them to top-level and package member suggestions.