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£¬°ïÄã¶¥
tianlesoftware ÊǸöºÃÈË!
ÒªºÃºÃµØ¿´¿´ËûµÄ²©¿Í!
{{----
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸ö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 ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......