当前位置: 代码迷 >> SQL >> PL/SQL惯用设置
  详细解决方案

PL/SQL惯用设置

热度:112   发布时间:2016-05-05 14:56:48.0
PL/SQL常用设置

??? 1) 自动保存数据库密码
??????? Tools->Preferences->Oracle->Logon History->Definition
??????? 选择Store with password。
???

??? 2)?快捷键?????????
??????? Tools->Preferences->User Interface->Key Configuration。

???????

??? 3) 自动生成代码??????

??????? Tools->Preferences->User Interface->Editor->AutoReplace

????????点击Edit进行编辑并保存。

??????? 如设置se=select * from时,在Editor里,输入se并敲一下空格键就会自动生成select * from了。


??????? 常用的如下:


??????? se = select * from
??????? wh = where
??????? ins = insert into values()
??????? de = delete from
??????? fo = for update
????????gr = group by
??????? up = update? set
??????? ord =order by
??????? tr = trunc(sysdate)
??????? td = to_date('','yyyy-MM-dd HH24:mi:ss')
????????tc = to_char(,'yyyy-MM-dd HH24:mi:ss')

???????
??????? Tools->Preferences->User Interface->Editor->Syntax Highlighting
??????? Keyword case用于设置SQL关键字的显示风格,可根据自己的习惯进行设置。

?

????????Tools->Preferences->User Interface->Editor->Other
????????Highlight edit line用于设置是否高亮显示光标所在行,可根据自己的习惯进行设置。

????????
??? 4) 字体设置??????

??????? Tools->Preferences->User Interface->Fonts
???????????????
???? 5) F8自动执行当前行Sql

???????? Tools->Preferences->Window Types->SQL Window
???????? 把AutoSelect statement选上。
?????????????

  相关解决方案