易截截图软件、单文件、免安装、纯绿色、仅160KB

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.


相关文档:

查看、修改oracle字符集,查看oracle版本

方法一:
1)   查看服务器端字符集:                                         &nbs ......

查看oracle执行计划

日常开发活动中,有时候需要对oracle执行计划进行监控,以此来调优程序和数据库方面的性能。
常用方法有以下几种:
一、通过PL/SQL Dev工具
    1、直接File->New->Explain Plan Window,在窗口中执行sql可以查看计划结果。其中,Cost表示cpu的消耗,单位为n%,Cardinality表示执行的行数,等价Row ......

oracle工具环境


SQLPlus是oracle提供的一个命令行执行的工具
SQLPlus中用两种命令:
    sqlplus:以命令行的方式进入数据库连接
    sqlplusw:以窗口的形式启动命令行工具  注:主机字符串,输入数据库名称
             &n ......

在oracle中关于树的sql

表task,字段id_,name_
id_的数据如下形式:
1
1.1
1.1.1
1.1.1.2
1.2
1.2.1
...
10
10.1
10.1.1
10.2.1
10.2.1.1
10.2.1.1.1
10.2.1.1.2
.......
注:“.”标识父子的关系。
现在通过id_查询树结构的效果,并且知道此节点是否为叶子节点leaf。。?
语句如下:
select
......

Oracle Instant Client安装


软件下载
到http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html下载如下三个包:
instantclient-basic-win32-11.1.0.7.0.zip
instantclient-jdbc-win32-11.1.0.7.0.zip
instantclient-sqlplus-win32-11.1.0.7.0.zip
将这三个包分别解压,然后内容放到D:\instantclient_11_1下
......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号