´ó¼ÒËÓõÄOracle 11g
ÓÃOracle11g ÔõôҲµô²»³öSQLPLUSÄǸöÏñ10gÖеÄÄǸö°×ÆÁÀ´£¬Ö»ÄÜÃæ¶ÔÒ»¸ö°×ÆÁÏñÇÃDOSÃüÁîÒ»Ñù¡£ ÎÒ¸Õ¿ªÊ¼Ñ§Ï°£¬»¹ÓкܶàSQLÓï¾ä£¬ÌرðÊDzéѯselectÓï¾äÒª¼ÓÇ¿£¬ÎÒ×îµ£ÐÄÕâÒ»¿éÁË£¬ÔÚѧϰSqlServer2000µÄʱºòÒ²ÊÇÕâÒ»²¿·ÖѧµÃ²»ºÃ£¬Ã»Ïëµ½ÔÚOracleÖÐÓÖÓöµ½ÁË£¬ÔÙ¼Ó½ôÒ»µã£¬×öÌâÄ¿µÄʱºò¶à×¢Òâµã¡£ ½ñÌìÏÂÎçѧϰµÄÊÂÎñµÄ¸ÅÄÔ×ÓÐÔ¡¢Ò»ÖÂÐÔ¡¢¸ôÀëÐÔ¡¢³ÖÐøÐÔ¡£ ×£¸£ÎÒOracleÄܹ»Ñ§ºÃ£¡
ÒýÓà Äã˵µÄÊÇsqlplusw°É£¿ 11g°ÑËü¸øÈ¥µôÁË ¶àÁ˸ösql developer ½¨ÒéÄãʹÓÃplsql developer ÎҵĵçÄÔÉÏÔõôûÕÒµ½ÄØ£¿ºÇºÇ¡£¡£»¹ÊÇÓÃsqlplus°É¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
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Ä ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷ µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿ È磺 ......