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

Oracleѧϰ¼Æ»®

ÏëϵͳѧϰOracle£¬Ä¿Ç°×ö¿ª·¢£¬Ï¶¨¾öÐÄѧoracleÁË£¬ÄÜɹһÏÂѧϰ¼Æ»®Ã´£¿ÓÐ4Äêʱ¼ä¡£


OracleÅàѵ°àÖµµÃÈ¥£¿
ÏÈ¿´ÖÐÎĹٷ½Îĵµ£¬»¹ÊÇÓ¢ÎĹٷ½Îĵµ£¨Ó¢ÓïÒ»°ã£©£¿
»¹ÊÇ¿´Êé¼®£¿ ÄÄЩÊé¼®ÈëÃűȽϺ㬵±µ±ÍøÒ»ËÑOracleÏà¹ØµÄÓÐ1000¶à±¾Êé¡£


·Ö²»¶à£¬Ï£Íû´ó¼Ò¶à¸øÐ©¹ÄÀø£¬ctl+c ctl+v¾Í±ðÀ´ÁË¡£
Ö÷ÒªÊÇÍøÉÏÒ»ËÑ£¬Ñ§Ï°×ÊÁÏN¶à£¬¸÷ÖÖ¶¼ÓУ¬²»ÖªµÀÈçºÎÏÂÊÖ¡£Çë´ó¼Ò½áºÏ×Ô¼ºµÄÇ×ÉíÌå»á¸æËßÎÒ°Ñ!


ÏÈ¿´±¾ÈëÃŵÄÊ飬Á˽âÏ´óÖ½ṹ£¬ÍƼö¸Ç¹úÇ¿µÄ¡¶Oracle 10g Ñ­Ðò½¥½ø¡·

È»ºóÔÚÂýÂýµÄÉîÈëµÄѧϰ¡£¡£


------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716

oracleÒ²Ö»¶®¿ª·¢Ó¦Óã¬×ö²»ÁËDBA£¬°ïÄã¶¥

ÒýÓÃ
ÏÈ¿´±¾ÈëÃŵÄÊ飬Á˽âÏ´óÖ½ṹ£¬ÍƼö¸Ç¹úÇ¿µÄ¡¶Oracle 10g Ñ­Ðò½¥½ø¡·

È»ºóÔÚÂýÂýµÄÉîÈëµÄѧϰ¡£¡£


------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716


tianlesoftware ÊǸöºÃÈË!
ÒªºÃºÃµØ¿´¿´ËûµÄ²©¿Í!
{{----


Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

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

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

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

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ