APEX Reactant Chrome Extension

Tool for sql autocomplete and table/column lookup in oracle apex.
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.

How to install APEX Reactant chrome extension in chrome Browser

You can Follow the below Step By Step procedure to install the APEX Reactant Chrome Extension to your Chrome Web browser.

• Step 1: Go to the Chrome webstore https://chrome.google.com/webstore or download the extension APEX Reactant Chrome Extension Download from https://pluginsaddonsextensions.com
• Step 2: Now search for the APEX Reactant in Chrome Webstore Search and click on the search button.
• Step 3: click on the APEX Reactant Chrome Extension Link
• Step 4: in the next page click on the Add to Chrome button to Download and Install the APEX Reactant extension for your Chrome Web browser .