Monday, May 13, 2019

Oracle SQL Developer Code Templates for APEX APIs

I recently added this repository on GitHub.

https://github.com/OraCoolAPEX/SQL-Developer-Code-Templates-APEX-APIs

If you use Oracle Application Express (APEX) API reference on SQL Developer, you may benefit from these code templates while working on a SQL Worksheet or PL/SQL Editor.

Preview


To Use It

  1. Use Ctrl + Space to manually activate the Completion Insight or check the automatic popup speed on Tools >> Preferences >> Code Editor >> Completion Insight
  2. To navigate through the parameters, use Tab to move forward or Shift + Tab to move backwards.
  3. Some parameters are pre-populated with their default values (if any) and others display their pre-defined possible values in /*comments*/.

To Configure It

  1. Download the CodeTemplate.xml that matches your current version of Oracle APEX (right now, only 18.2 is available).
  2. On Windows, navigate to C:\Users\<USER>\AppData\Roaming\SQL Developer:
    • If you do not have any previous Code Template defined, simply replace the existing CodeTemplate.xml file.
    • If you do have Code Templates defined, copy everything between the <rows></rows> tags on this CodeTemplate.xml file and paste it at the end of your existing file, right before the closing </rows> tag.
  3. Restart SQL Developer.

Troubleshooting

  1. Go to Tools >> Preferences >> Database >> SQL Editor Code Templates and make sure all the code templates are visible.
  2. Go to Tools >> Preferences >> Code Editor >> Completion Insight and make sure the following options are checked:
    • Enable Completion Auto-Popup in SQL Worksheet
    • Enable Completion Auto-Popup in PL/SQL Editor

Please feel free to provide any feedback or suggestions on how to improve or report any bugs in the comments below.