APEX Reactant
大小:26.22KiB版本:v 1.0更新时间:2021-12-21
Tool for SQL autocomplete and table/column lookup in Oracle APEX
APEX Reactant 的使用方法详解,最全面的教程
APEX Reactant 描述:
用户数:5
分类:开发者工具插件
扩展大小:26.22 KiB
最后更新时间:2021-12-21
版本:v 1.0
APEX Reactant 插件简介:
这是来自Chrome商店的 APEX Reactant 浏览器插件,您可以在当前页面下载它的最新版本安装文件,并安装在Chrome、Edge等浏览器上。
APEX Reactant插件下载方法/流程:
点击下载按钮,关注“扩展迷Extfans”公众号并获取验证码,在网页弹窗中输入验证码,即可下载最新安装文件。
APEX Reactant插件安装教程/方法:
(1)将扩展迷上下载的安装包文件(.zip)解压为文件夹,其中类型为“crx”的文件就是接下来需要用到的安装文件
(2) 从设置->更多工具->扩展程序 打开扩展程序页面,或者地址栏输入 Chrome://extensions/ 按下回车打开扩展程序页面
(3) 打开扩展程序页面的“开发者模式”
(4) 将crx文件拖拽到扩展程序页面,
完成安装如有其它安装问题,
请扫描网站底部二维码与客服联系如有疑问请参考:
https://www.extfans.com/installation/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.