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.
相关文档：
方法一：
1) 查看服务器端字符集： &nbs ......
SQLPlus是oracle提供的一个命令行执行的工具
SQLPlus中用两种命令：
sqlplus：以命令行的方式进入数据库连接
sqlplusw：以窗口的形式启动命令行工具 注：主机字符串，输入数据库名称
&n ......
表 tree
字段 master
sub
sales
insert into tree values
('主1', '主2', 15);
insert into tree values
('主1', '主3', 20);
insert into tree values
('主2', '主4', 5);
� ......
TO_DATE格式(以时间:2007-11-02 13:45:25为例)
Year:
yy two digits 两位年 ......
用Oracle Sql Developer操作表的时候，不知咋的把表锁住了。
结果那张表一插数据就死，连truncate都不行。
从网上七拼八凑了个方法，终于把进程杀了，表也就解锁了。
首先要用dba级别的用户操作，因为要察看很多系统表。用普通用户操作的话，会提示表或者View不存在。（为什么不提示权限不够？害我总以为是版本问题）
� ......
