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

¡¾ÇóÖú¡¿¹ØÓÚOracleÕâÖÖÐèÇóµÄ²éѯÓï¾ä²»Çå³þÔõôд

Êý¾Ý¿â±í¼Ç¼ÓУº

-----------ÈÕÆÚ--------------É豸״̬-------------------
  2010-02-05 10:25:10 S  
  2010-02-05 10:29:55 S  
  2010-02-05 10:30:12 C  
  2010-02-05 10:31:10 C  
  2010-02-05 10:33:15 S  
  2010-02-05 10:35:20 D  
  2010-02-05 10:37:19 D  
  2010-02-05 10:39:55 D  

Ŀǰ²éѯ½á¹û£¬ÒªÇó£º
1£©°´Ê±¼äÅÅÐò£¬Ë³Ðò²»ÄÜ´òÂÒ
2£©²éѯ[É豸״̬]²»Í¬µÄ¼Ç¼£¬Èç¹ûͬһ¸ö״̬Á¬Ðø¶àÌõ¼Ç¼£¬ÄÇôֻȡÕâ¸ö״̬µÄÊ×Ìõ£¬
  ±ÈÈç¼Ç¼Ϊ¡¾A,B,A,A,A,C,C¡¿£¬ÄÇô²éѯµÄÆÚÍû½á¹ûÓ¦¸ÃÊÇ¡¾A,B,A,C¡¿

ÉÏÃæÄ£ÄâµÄÊý¾Ý¿â¼Ç¼ÆÚÍûµÄ²éѯ½á¹ûÓ¦¸ÃΪ£º
-----------ÈÕÆÚ--------------É豸״̬-------------------
  2010-02-05 10:25:10 S  
  2010-02-05 10:30:12 C  
  2010-02-05 10:33:15 S  
  2010-02-05 10:35:20 D  

ÇëÎÊOracleµÄ²éѯÓï¾äÓ¦¸ÃÔõôд²Å¿ÉÒÔʵÏÖ£¿
лл¸÷λ£¡

ÒýÓÃ
ÉÏÃæÄ£ÄâµÄÊý¾Ý¿â¼Ç¼ÆÚÍûµÄ²éѯ½á¹ûÓ¦¸ÃΪ£º
-----------ÈÕÆÚ--------------É豸״̬-------------------
2010-02-05 10:25:10 S
2010-02-05 10:30:12 C
2010-02-05 10:33:15 S
2010-02-05 10:35:20 D

ÕâÀïÃæµÄÁ½¸öSΪʲô²»ÊÇÒ»×éµÄÄØ£¿ Ô


Ïà¹ØÎÊ´ð£º

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

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

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

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñ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 ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ