sqldeveloper

阅读文档: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),

上一篇:HDU 2545 树上战争 (并查集+YY)


下一篇:Unity 安卓Jar包的小错误