ËÄÜÍÆ¼ö¼¸±¾oracleµÄÊé»òÊÓÆµ - Oracle / ·Ç¼¼ÊõÇø
лл
ÎÒÒ²ÊÇÏëÖªµÀ me too ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ....... ¸öÈ˾õµÃÔÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½ÌµÄ»° ÖÐÎĵÄÊéÎÒ¿´¹ýµÄ´ó²¿·Ö¶¼ÊÇÄǸöORACLEPRESS³ö°æµÄ MCGRAWHILL ûÓÐÌý˵¹ý°¡£¡ ÓÐûÓпª¹ýÕâ±¾ÊéµÄ£¬¸ø¸ö½¨Ò飿.. 3Q£¡~ÒýÓà ûÓÐÌý˵¹ý°¡£¡ ºÇºÇ ÎÒ˵µÄÄǾ仰¿ÉÄÜÓеãÆçÒå ÖÐÎĵÄÊéÎÒ¿´¹ýµÄ´ó²¿·Ö¶¼ÊÇÄǸöORACLEPRESS³ö°æµÄ MCGRAWHILL ¾ÍÊÇ˵ORACLEPRESS³ö°æµÄÊéÉÏÓ¡Á˸öMCGRAWHILLµÄLOGO MCGRAWHILL²»ÊÇÊéÃû oracle 10g Êý¾Ý¿â¹ÜÀíÓëÓ¦ÓÃϵͳ¿ª·¢ ÀîÏþÀè µÈ±àÖøµÄ£¬»ù±¾µÄ²Ù×÷»¹ÊDZȽÏÇåÎúµÄ£¬²»¹ýÊý¾Ý¿âµÄÊ鲻ͬµÄÊéÔÚ²»Í¬µÄ·½Ãæ²àÖØ²»Ò»Ñù £¬¶à¿´Ïà¹ØµÄ¼¸±¾¡£ ÊÓÆµµÄ»° С²¼ÀÏʦµÄORACLE½²µÄºÃÏñ»¹¿ÉÒÔ Â¥Ö÷¿ÉÒÔÈ¥ËÑËÑ¿´¿´ ͦ¶àµÄ UpµÈÍÆ¼ö~ Oracle_9i_DBA_Fundamentals лл¡£Ð¡²¼ÀÏʦµÄÊÓÆµ£¬¸ÕËÑÁËһϣ¬Óв»ÉÙ£¬»Ø¼ÒÏÂÔØ¡£
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸ö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 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÏÖÓÐÒÔÏÂÊý¾Ý£º ID Name 1 Jack,Tom,Ben 2 Mary,Simth,Tony,Jay ת»»Îª£º ID Name 1 Jack 1 Tom 1 Ben 2 Mary 2 Simth 2 Tony 2 Jay ÒªÇóʹÓÃSQL²éѯÍê³É£¬ÓÉÓÚÌõ¼þÏÞÖÆ£¬²»ÄÜʹÓà ......