APEX Reactant: SQL Autocomplete and Table/Column Lookup Extension
APEX Reactant is a powerful Chrome extension developed by Catalyst Fire. Designed specifically for Oracle APEX applications, this tool provides SQL autocomplete functionality and table/column lookup capabilities. With APEX Reactant, you can streamline your SQL coding process and improve productivity.
One of the key features of APEX Reactant is its ability to auto-complete SQL statements based on a mapping of keywords to table names. For example, if you have a table called CUSTOMER_MEMBERSHIP with the key "CME", you can simply type "SCME" and hit tab to automatically generate a select statement for the CUSTOMER_MEMBERSHIP table.
This extension offers 9 command keys, including S, J, W, K, I, F, L, T, and C. Each command allows you to quickly create SQL statements with different variations. For instance, the "S" command generates a select statement for a given table, while the "W" command adds a "where" clause to the select statement. Additionally, the "T" and "C" commands prompt you for input to search for specific table or column names.
APEX Reactant also provides an options page where you can customize the mapping of table names and table keys. Furthermore, you can override the F5 key to prevent browser refresh and instead run SQL commands directly within the SQL commands page in Oracle APEX.
This free Chrome extension is a valuable tool for Oracle APEX developers, offering efficient SQL autocomplete and table/column lookup capabilities. With APEX Reactant, you can enhance your coding experience and save time on SQL development tasks.
