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

´ó¼ÒË­ÓõÄOracle 11g

ÓÃOracle11g ÔõôҲµô²»³öSQLPLUSÄǸöÏñ10gÖеÄÄǸö°×ÆÁÀ´£¬Ö»ÄÜÃæ¶ÔÒ»¸ö°×ÆÁÏñÇÃDOSÃüÁîÒ»Ñù¡£
ÎÒ¸Õ¿ªÊ¼Ñ§Ï°£¬»¹ÓкܶàSQLÓï¾ä£¬ÌرðÊDzéѯselectÓï¾äÒª¼ÓÇ¿£¬ÎÒ×îµ£ÐÄÕâÒ»¿éÁË£¬ÔÚѧϰSqlServer2000µÄʱºòÒ²ÊÇÕâÒ»²¿·ÖѧµÃ²»ºÃ£¬Ã»Ïëµ½ÔÚOracleÖÐÓÖÓöµ½ÁË£¬ÔÙ¼Ó½ôÒ»µã£¬×öÌâÄ¿µÄʱºò¶à×¢Òâµã¡£
½ñÌìÏÂÎçѧϰµÄÊÂÎñµÄ¸ÅÄԭ×ÓÐÔ¡¢Ò»ÖÂÐÔ¡¢¸ôÀëÐÔ¡¢³ÖÐøÐÔ¡£
×£¸£ÎÒOracleÄܹ»Ñ§ºÃ£¡


ÒýÓÃ
Äã˵µÄÊÇsqlplusw°É£¿ 11g°ÑËü¸øÈ¥µôÁË ¶àÁ˸ösql developer
½¨ÒéÄãʹÓÃplsql developer

ÎҵĵçÄÔÉÏÔõôûÕÒµ½ÄØ£¿ºÇºÇ¡£¡£»¹ÊÇÓÃsqlplus°É¡£


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

oracle´¥·¢Æ÷²åÈëÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ