Oracle驱动classes12.jar 与ojdbc14.jar的区别
以下是Oracle JDBC官方文档的说法：
也就是随便翻译一下就理解了。
JDBC Thin for All Platforms
classes12.jar (1,600,090 bytes) - for use with JDK 1.2 and JDK 1.3
在低级JDK版本1.2与1.3中使用的驱动，虽然实际上在1.4，1.5中使用大部分情况也是OK的
classes12_g.jar (2,044,594 bytes) - same as classes12.jar, except that classes were compiled with "javac -g" and contain some tracing information.
添加了编译调试信息的classes12.jar
classes12dms.jar (1,607,745 bytes) - same as classes12.jar, except that it contains additional code`to support Oracle Dynamic Monitoring Service.
添加了支持Oracle动态检测服务的classes12.jar
classes12dms_g.jar (2,052,968 bytes) - same as classes12dms.jar except that classes were compiled with "javac -g" and contain some tracing information.
添加了支持Oracle动态检测服务与编译调试信息的classes12.jar
ojdbc14.jar (1,545,954 bytes) - classes for use with JDK 1.4 and 1.5
在高级JDK版本1.4与1.5中使用的驱动
下面三个同classes12.jar的情况
ojdbc14_g.jar (1,938,906 bytes) - same as ojdbc14.jar, except that classes were compiled with "javac -g" and contain some tracing information.
ojdbc14dms.jar (1,553,561 bytes) - same as ojdbc14.jar, except that it contains additional code`to support Oracle Dynamic Monitoring Service.
ojdbc14dms_g.jar (1,947,136 bytes) - same as ojdbc14dms.jar, except that classes were compiled with "javac -g" and contain some tracing information.
orai18n.jar (1,645,114 bytes) - NLS classes for use with JDK 1.2, 1.3, 1.4, and 1.5. This jar file replaces the old nls_charset jar/zip files.
ons.jar (48,492 bytes) - for use by the pure Java client-side Oracle Notification Services (ONS) deamon.
demo.tar (604,160 bytes) or demo.zip (529,267 bytes) - contains sample JDBC programs.
相关文档：
最近发现一个问题，一个9i跑在redhat5的，居然 select sysdate from dual 出来的时间和实际时间差了几分钟，因为基于这个oracle的系统时间正确性还是有点要求的。所以只能 #date -s 2010-2-10 8:55:00 了，再#clock -w 写入COMS 注意修改时间得在root下。
在系统启动时，Linux操作系统将时间从CMOS中读到系统� ......
select p.spid,
a.serial#,
c.object_name,
b.session_id,
b.oracle_username,
b.os_user_name
from v$proces ......
方法一：
1) 查看服务器端字符集： &nbs ......
1. Oracle安装完成后的原始口令？
internal/oracle
sys/change_on_install
system/manager
scott/tiger
sysman/oem_temp
2. ORACLE9IAS WEB CACHE的原始默认用户和密码？
administrator/administrator
3. oracle 8.0.5如何建立数据库？
用orainst。假如有motif界面，能够用orainst /m� ......
对于 Oracle 的 rownum 问题，很多资料都说不支持>,>=,=,between...and，只能用以上符号(<、<=、!=)，并非说用>,>=,=,between..and 时会提示SQL语法错误，而是经常是查不出一条记录来，还会出现似乎是莫名其妙的结果来，其实您只要理解好了这个 rownum 伪列的意义就不应该感到惊奇，同样是伪列，rownum ......
