from injection shell sql to_程序小白数据库篇： PL/SQL快捷输入设置

两种快捷键的设置方式

1. 快速打开SQL窗口，快速执行类的快捷键设置方法

设置快捷操作键

选择之后直接点击键盘就可以将所要的快捷键设置到第二列中。

2. SQL语句快捷键设置， 如：输入 sf +空格 ，打印 SELECT * FROM

自行设置txt文件即可

点击Edit可以设置基本的SQL语句快捷键。

可在线进行编辑

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' )