PL/SQL 自動補全[轉]

標籤：and   row   blog   mil   order by   like   pre   replace   too   

1.建立 shortcuts.txt 內容如下：

  s = SELECT t.* FROM  t  w = WHERE  b = BETWEEN  AND  l = LIKE ‘%%‘  o = ORDER BY  insw = IN (SELECT a FROM  a WHERE a )  sw = SELECT t.* FROM  t WHERE t  sc* = SELECT COUNT(*) FROM  t  st = SELECT t.* ,t.ROWID FROM  t  f = FOR UPDATE  u = UPDATE  t SET t. WHERE t   

複製到D:\Program Files (x86)\PLSQL Developer\PlugIns目錄下

 2.菜單中選 Tools -> Perferences -> Editor -> Autoreplaces

 3.重啟PL/SQL Developer，輸入等號左側縮寫按下“空格”，會自動補全。

 

文章轉自:http://www.cnblogs.com/zhanggaosong/p/4668542.html

PL/SQL 自動補全[轉]