Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle JDBC ×Ô´øÁ¬½Ó³Ø

 http://www.diybl.com/course/3_program/java/javajs/2008429/111906.html
Èç¹ûҪʹÓóصϰ,¾Í±ØÐëʹÓÃOracleConnectionCacheImpl,¹²ÓÐÈýÖֳصIJßÂÔ:
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 Êý¾ÝÔ´ÖеÄÁ¬½Ó¸ßËÙ»º´æ


Ïà¹ØÎĵµ£º

OracleÖеÄNullÖµ½âÎö

         ÓÐÈË×ܽáÁËÊý¾Ý¿âÖÐNullÖµµÄ¸ÅÄ±È½Ï¾«Á¶£¬ÕªÂ¼ÈçÏ£º
NullÊÇÊý¾Ý¿âÖÐÌØÓеÄÊý¾ÝÀàÐÍ£¬µ±Ò»Ìõ¼Ç¼µÄij¸öÁÐΪNull£¬Ôò±íʾÕâ¸öÁеÄÖµÊÇδ֪µÄ¡¢ÊDz»È·¶¨µÄ¡£¼ÈÈ»ÊÇδ֪µÄ£¬¾ÍÓÐÎÞÊýÖֵĿÉÄÜÐÔ¡£Òò´Ë£¬Null²¢²»ÊÇÒ»¸öÈ·¶¨µÄÖµ¡£
ÕâÊÇNullµÄÓÉÀ´¡¢Ò²ÊÇNullµÄ»ù´¡£¬ËùÓк ......

oracle ±Ê¼Ç V Ö®´¥·¢Æ÷ (TRIGGER)

 ´¥·¢Æ÷ trigger
·ÖÀࣺǰ´¥·¢£¬ºó´¥·¢
      Ðд¥·¢Æ÷£¬Óï¾ä´¥·¢Æ÷
Ðд¥·¢Æ÷ÓëÓï¾ä´¥·¢Æ÷µÄÇø±ð£º
Ðд¥·¢Æ÷ÒªÇóµ±Ò»¸ö DML Óï¾ä²Ù×÷Ó°ÏìÊý¾Ý¿âÖеĶàÐÐÊý¾Ýʱ£¬¶ÔÓÚÆäÖеÄÿ¸öÊý¾ÝÐУ¬Ö»ÒªËüÃÇ·ûºÏ´¥·¢Ô¼ÊøÌõ¼þ£¬¾ù¼¤»îÒ»´Î´¥·¢Æ÷,FOR EACH ROW Ñ¡Ïî˵Ã÷´¥·¢Æ÷ΪÐд¥·¢Æ÷£»
Óï¾ä´¥·¢Æ÷ ......

oracleÁÙʱ±íÏà¹ØÖªÊ¶

 ÔÚOracle8i»òÒÔÉϰ汾ÖУ¬¿ÉÒÔ´´½¨ÒÔÏÂÁ½ÖÖÁÙʱ±í£º
1¡£»á»°ÌØÓеÄÁÙʱ±í
    CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>)
    ON COMMIT PRESERVE ROWS£»
  
2¡£ÊÂÎñÌØÓеÄÁÙʱ±í
    CREATE GL ......

oracle½¨Á¢±í¿Õ¼ä

1.oralceɾ³ýÃüÁî
1.1.ɾ³ýÓû§
drop user username cascade;
1.2.ɾ³ý±í¿Õ¼ä
DROP TABLESPACE dataspace INCLUDING CONTENTS AND DATAFILES;
2.´´½¨±í¿Õ¼ä
2.1.½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE dataspace
DATAFILE '/Ŀ¼/dataspace.dbf' SIZE 500M
UNIFORM SIZE 128k; //Ö¸¶¨Çø³ß´çΪ128k,Èç²»Ö¸¶¨£¬Çø³ß´çĬÈÏÎ ......

oracleÊý¾Ýµ¼Èëµ¼³ö


µ¥±íÊý¾ÝÇ¨ÒÆ£ºÖ§³Öclob,blob
      exp estarcom/estarcom@ORACLE  tables=AA direct=y file=C:/AAA1.dmp
¡¡¡¡ imp estarcom/estarcom@ORACLE  tables=AA  file=C:/AAA1.dmp fromuser=estarcom touser=estarcom
È«¿âÊý¾ÝÇ¨ÒÆ
exp userid=zhongxin/zhongxin@ORACLE own ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ