http://www.diybl.com/course/3_program/java/javajs/2008429/111906.html
如果要使用池的话,就必须使用OracleConnectionCacheImpl,共有三种池的策略:
DYNAMIC_SCHEME(是动态增加.用完如果超过上限则关掉)
The cache will create connections above the specified maximum limit
when necessary but will in turn close connections as they are
returned to the cache until the number of connections is within the
maximum limit. Connections will never be cached above the maximum
limit. This is the default setting.
FIXED_RETURN_NULL_SCHEME (直接返回Null)
The cache will return a null connection once the maximum connection limit has been exceeded.
FIXED_WAIT_SCHEME (始终等待)
The cache will wait until there is a connection available and will then return it to the calling application.
oracle.jdbc.pool
Class OracleConnectionCacheImpl
http://download.oracle.com/otn/utilities_drivers/jdbc/101020/javadoc/index.html
oracle Javadoc JDBC 11.2.0.1
http://publish.it168.com/2005/1215/20051215001801.shtml
OC4J 10g 10.1.3 数据源中的连接高速缓存
在Oracle8i或以上版本中，可以创建以下两种临时表：
1。会话特有的临时表
CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>)
ON COMMIT PRESERVE ROWS；
2。事务特有的临时表
CREATE GL ......
装了个Oracle 10g，却发现找不到企业管理器了。原来10g又升级了管理工具，不再采用8i, 9i的那些Java工具了，而是与时俱进地改用了Web方式。按照网上的方法：http://机器的IP地址:5500/em，还是没有连上。难道端口号不对吗？
查看Oracle 10g安装目录install下的readme文件：
显示：
数据 ......
1. ASCII
返回与指定的字符对应的十进制数;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
给出整数,返回对应的字符;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH C
-- ......
