Tool for SQL autocomplete and table/column lookup in Oracle APEX

Latest Version

Version

1.0

Update

October 4, 2021

Size

26.22KiB

Developer

APEX Reactant Extension

This extension is a tool to auto-complete SQL statements within an Oracle APEX application. After you set up a mapping of keywords to table names you can use this extension to create SQL commands based on certain command letters. So if there is a table called CUSTOMER_MEMBERSHIP and it's key is CME, you can type SCME hit tab and it will automatically create a select statement from the CUSTOMER_MEMBERSHIP table.

There are 9 command keys as of this version, they are S, J, W, K, I, F, L,T, and C. Entering any of these letters before a valid table key will create a SQL statement.

S = Select * from {Table Name}
J = Join {Table Name} on
W = Select * from {Table Name} where
K = Select * from {Table Name} where {Key Column Name} = {key that you have copied to your clipboard}
I = Select * from {Table Name} where {Key Column Name} in ({list of keys that you have copied to your clipboard})
F = Select * from {Table Name} where rownum <= 10
L = Left join {Table Name} on

T and C are different than the other commands in that they do not require a table key and they will prompt you for input, all that is needed to trigger this is to to T or C and hit tab. They will ask for either or table name or column name to search for and it will return tables or columns that match your search term.

The options page for this extension allows you to define the mapping of table names and table keys as well as override the f5 key to prevent it from refreshing your browser and instead it will run SQL commands within the SQL commands page in Oracle APEX.

Source Manifest.json

{"update_url": "https://clients2.google.com/service/update2/crx",\t"author": "Catalyst Fire",\t"name": "APEX Reactant",\t"description": "Tool for SQL autocomplete and table/column lookup in Oracle APEX",\t"version": "1.0",\t"manifest_version": 2,\t"options_ui": {\t\t"page": "options.html",\t\t"open_in_tab": false\t},\t"content_scripts": [\t\t{\t\t\t"matches": [\t\t\t\t"http://*/*/f?p*",\t\t\t\t"https://*/*/f?p*",\t\t\t\t"http://*/f?p*",\t\t\t\t"https://*/f?p*"\t\t\t],\t\t\t"js": [\t\t\t\t"APEXScript.js"\t\t\t]\t\t}\t],\t"permissions": [\t\t"clipboardRead",\t\t"storage"\t\t\t],\t"browser_action": {\t\t"default_popup": "popup.html",\t\t"default_icon": {\t\t\t"16": "/images/favicon.png",\t\t\t"32": "/images/favicon.png",\t\t\t"48": "/images/favicon.png",\t\t\t"128": "/images/favicon.png"\t\t}\t}}

Download CRX(26.22KiB)