ÐÂÊÖѧϰOracleÓÃʲô°æ±¾£¬ÔÚÄÄÏ£¿
Ö»¶Ô¹ØÏµÊý¾Ý¿âÓïÑÔSQLÓÐÀíÂÛÉϵÄÁ˽⣬ÒòΪSQL ServerÅäÖÃÀÏÊdzöÎÊÌ⣬ËùÒÔ¾ö¶¨ÓÃOracleѧÊý¾Ý¿â¡£ÎÒÊÇË«ºË1GÄڴ棬ÓÃʲô°æ±¾£¬11GÐÐÂð£¿ºÃ¶à°æ±¾£¬²»ÖªµÀÑ¡ÄǸö
º¹,ѧ±ê×¼SQL°¡,ÓÃACCESS¾Í¿ÉÒÔÁË,ϸöMYSQLÖ®ÀàµÄÒ²¿ÉÒÔ
1GÄÚ´æÅÜ11G¿ÉÒÔ°¡,µ«ÊÇÄã»úÆ÷É϶«Î÷¶àÁË,ÄǾÍÄÑ˵ÁË,ÔÙ×°¸öVS 2010,¿ÉÄܾÍÅÜµÃ´ÆøÁËŶ,9IºÍ10G¿ÉÒÔÊÔÊÔ,
11.2 for windows°æ±¾»¹Î´³ö£¬½¨Òé10.2¡£
http://www.oracle.com/technology/software/products/database/index.html
Good Luck£¡~ ¹²Ã㣡~
ÓÃ9I°É£¬¶ÔÓÚ³õѧÕ߲̫¶à¡£
ллÁË£¬ÊµÏ°µ¥Î»ÓÃSQL Server£¬ÎÒ»¹ÊÇÑо¿Ñо¿°É
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨
ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off cli ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿
SQL code:
SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......