Oracle´´½¨±íµÄÒÉÎÊ
ÎÒÔÚÉÏÃæµÄλÖô´½¨±íµÄʱ¼äÔõôÕÒ²»µ½¡°±í¡±Õâ¸öͼ±ê°¡£¬Òªµã»÷ÂÌÉ«µÄÄǸöͼ±ê¡°´´½¨¡±À´
´´½¨±í°¡£¬»¹Óд´½¨Íê±íºóÔõôÔÚÏÂÃæµÄͼÖп´²»µ½¸Õ²Å´´½¨µÄ±í°¡
ͼƬºÃÏñÓÐÎÊÌ⣬ÎÒÔÚ´«Ò»´ÎͼƬ
ÎÞͼÎÞÕæÏà¡£¡£¡£
Â¥Ö÷create table Óï¾ä×Ô¼ºÐ´°É¡£¡£¡£
¿´²»µ½Í¼Æ¬£¬¿ÉÄÜÊÇÄãûÓÐˢС£
http://img124.ph.126.net/rm-5ZKVG-enqjiG2Od4oig==/1611444241669938010.jpg
Õâ¸öͼÇë¶ÔÕÕ¿´ÏÂ
´´½¨Íê±ÏºóÄãË¢ÐÂÏ¿´¿´ÓÐûÓУ¿
Ë¢ÐÂÁË
ÎÊÌâ½á¾ÖÁË Ð»Ð»Â¥ÉϵÄ
http://wenwen.soso.com/z/q154797732.htm
´ò½´Ó͵Ä
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸ö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µÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨
ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off cli ......