??? 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选上。
?????????????