阅读文档:e12152-08
preferences 首选项,参数
panes 窗格
tabs 标签,选项卡
pin 别针,钉住
detach,move,dock
分离,移动,停靠
find database object pane 查找数据库对象 view menu中找
tab
pane
navigator
files navigator
reports navigator
connections navigator
tooltip
问题
如果查询某个表时,结果某些中文字是方框,某些正常显示。
选择合适的字体就可以了,preferences>code editor>fonts>cjk sc regular
更改界面语言
刚升级了SQL_DEVELOPER,发现它读取了系统用户默认的语言,出现中文界面,可是那个字体……真叫一个囧啊!
改回英文吧,特地记下改回去的方法,在Oracle官方论坛找到的。
在sqldeveloper\sqldeveloper\bin\sqldeveloper.conf文件中加入
AddVMOption -Duser.language=EN
AddVMOption -Duser.region=US
OK!
win8,win2k8自带jdk的sqldeveloper的解压不能启动问题
报错:丢失msvcr100.dll ,不能启动jvm.dll,
总共弹出两个窗口
解决办法如下:
Solution:
- Run regedit as the Administrator
- Expand HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths
- Add a new Key to App Paths called sqldeveloper.exe
- Set the (Default) value to the full path to the executable (including the executable name).
- Create a new String value for sqldeveloper.exe calledPath and set its value to thejre / bin folder in the SQLDeveloper files.
And here’s what it looks like:
This problem isn’t limited to Oracle SQLDeveloper. It will be common to any application distributed without an installation process that is dependent on a runtime file that was formerly located in the Windows folder.
业务表及字段英文解释
appeal 投诉,申诉
cashback 返现
recharge 充值
withdraw 提现
waybill 运单
settlement 结算
specialline 专线
freight 运费
penalty 罚款,处罚
用过,熟悉的对话框(参考e12152-08)
1.菜单命令-tools-database export 对话框-export wizard
export ddl中的 add byte keyword,
add force to views
其中LCPSYS.就是指show schema,
7 BYTE就是指 include BYTE keyword,字节与字符
CREATE TABLE "LCPSYS"."TEAA"
( "FILE#" NUMBER,
"STATUS" VARCHAR2(7 BYTE),