Overview
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.
Details
- Version1.0
- UpdatedOctober 4, 2021
- Offered byCatalyst Fire
- Size26.22KiB
- LanguagesEnglish
- Developer
Email
ken.wong@catalystfire.com - Non-traderThis developer has not identified itself as a trader. For consumers in the European Union, please note that consumer rights do not apply to contracts between you and this developer.
Privacy
This developer declares that your data is
- Not being sold to third parties, outside of the approved use cases
- Not being used or transferred for purposes that are unrelated to the item's core functionality
- Not being used or transferred to determine creditworthiness or for lending purposes
