两种快捷键的设置方式
1. 快速打开SQL窗口,快速执行类的快捷键设置方法
![588a51903ffcfbfd9eaa8f5e39924ac0.png](https://i-blog.csdnimg.cn/blog_migrate/0e11207e65cc8c366c9e515f1dfeb060.jpeg)
![a9423b09c1ff58be6bedfe959694cfea.png](https://i-blog.csdnimg.cn/blog_migrate/ae87d7eb934b876b2281d2b136aac27d.jpeg)
设置快捷操作键
选择之后直接点击键盘就可以将所要的快捷键设置到第二列中。
2. SQL语句快捷键设置, 如:输入 sf +空格 ,打印 SELECT * FROM
![0075a34e15fa3754a8e92b261149fa5a.png](https://i-blog.csdnimg.cn/blog_migrate/49dbb069865982d3a03a671d6ad9f38c.jpeg)
自行设置txt文件即可
点击Edit可以设置基本的SQL语句快捷键。
![570a3047809e1bd9c69c6c6fa73675dc.png](https://i-blog.csdnimg.cn/blog_migrate/cf670f00eff91dc37b6dbd60c14f5d99.jpeg)
可在线进行编辑
3. Shortcut.txt 内容:(可根据自己操作习惯进行补充)
s = select
f = from
w = where
fd = from dual
o = order by
g = group by
s8 = select * from
sf = select * from
fu = for update
usw = update set where
dis = distinct
bet = between and
dg = start with connect by prior
num = number := 0 ;
var2 = varchar2(2000) := '' ;
out = dbms_output.put_line();
xh = for iI in 1..100 loop
ep = end loop;
ex = exception
wndf = when no_data_found
tc4 = to_char( sysdate , 'yyyy')
tc6 = to_char( sysdate , 'yyyy-mm')
tc8 = to_char( sysdate , 'yyyy-mm-dd')
tc12 = to_char( sysdate , 'yyyy-mm-dd hh24:mi:ss' )
td4 = to_date( '2010' , 'yyyy')
td6 = to_date( '201010' , 'yyyy-mm')
td8 = to_date( '20101010' , 'yyyy-mm-dd')
td12 = to_date( '20101010 10:10:10 ' , 'yyyy-mm-dd hh24:mi:ss' )