关于myeclipse中的DB Browser连接Oracle数据库的问题
我的myeclipse是6.5版, oracle是10.2.0.1的中文版.
myeclipse启动是英文的,DB Browser死活连不上oracle,报两个错误(具体不记得了).后来看了如下文章,知道了原因。
---------------------------------------------------------------------------------------------------------------------------
Hi,
a quick update on this for all interested parties as I had to research
into the very same problem and only found partial answers around.
I am not an Oracle representative so whatever I'm saying, you cannot
blame Oracle for it, and you should check for yourself if in doubt.
This is a known bug for Oracle with 10.2.x (up to 10.2.0.1) drivers
relating to mixing language and locales, e.g. en_DE or en_IT.
Normally you can set user.language and user.country or NLS_LANG with
vmargs on the Eclipse command line, but these drivers will not be able
to mix a language with a territory using a particular method, which
seems to be the method mostly everybody uses today :-)
It is declared as fixed in 10.2.0.2, for en_DE at least according to the
metalink db.
There is a patch for Oracle DBMS 10.2.0.2 on Windows available to
supported customers, but it is not available as a public download as of
today. I just checked and the 10.2.0.2 dist is available for public
download for Linux; adventurers might want to try downloading the whole
distro to extract the jdbc drivers. Check licenses carefully to
understand if it's acceptable - I'm not going to do it so I didn't
elaborate.
People with metalink access can monitor entry #4629654 (which is
specific to en_DE) and related entries to stay updated.
Currently, the easiest workaround is downgrading to 10.1 drivers, unless
you need 10.2 explicitly of course.
Generally speaking, if you routinely update your jdbc drivers only
because they become available, well my advice is simply *change habit*,
and update only if you need to do it for some specific reason. Bugs are
frequently solved and re-introduced, unfort
相关文档:
1.绝对值
S:select abs(-1) value
O:select abs(-1) value from dual
2.取整(大)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.取整(小)
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.取整(截取)
......
安装
1. 完成RAC安装前的准备工作
1.1 同正常安装Oracle RAC的安装前配置。主要包括以下几个部分:
(1) 软硬件环境检查
(2) 网络配置
(3) 相关用户和目录的创建
(4) 用户环境及系统环境设置
(5) 配置远程访问
(6)  ......
小型机路线,几乎已被封死。无法使用Sun,它已和Oracle紧密绑定,若还使用上述设计,会很难说服售前将小型机、存储、数据库分别从不同厂商采购;另外,亦无法使用IBM,据说FLY的某个老板不喜欢。 大力推进数据库系统PC化,这似乎是最佳策略。FLY应用对数据 ......
ORACLE日期时间函数大全
TO_DATE格式(以时间:2007-11-02 13:45:25为例)
Year:
yy two digits 两位年   ......
select t.OSUSER,t.STATUS,t.LOGON_TIME from v$session t
select t.OSUSER,t.STATUS,t.LOGON_TIME from v$session t where t.OSUSER='admin'
select t.OSUSER,t.STATUS,t.LOGON_TIME from v$session t where t.OSUSER='liuzhaoqing'
select t.OSUSER,t.STATUS,t.LOGON_TIME from v$session t where t.OSUSER='ymx'
sel ......