Oracle ¹ØÏµ±íÖд洢XML½á¹¹µÄÊý¾Ý
×î½ü×ö¸öÏîÄ¿£¬Ç°Ì¨ÎÒÓõÄflex ÓÃjavaÁ¬½ÓµÄOracle ÏÖÔÚÎÊÌâÊÇÕâÑùµÄ ÎÒÉú³ÉÒ»¸öxml½á¹¹µÄÊý¾Ý È»ºóÓÃtoXMLString½«Ëüת»»ÁËÏ£¬´æÈëOracleÖеĹØÏµÊý¾Ý¿âÖУ¬XMLÊý¾Ý²»ÊǺܳ¤Ê± ¿ÉÒÔ±£´æ³É¹¦ ¿ÉÊÇXMLÊý¾Ý³¬¹ýÒ»¶¨³¤¶Èºó¾Í±£´æ²»ÁË
ºóÀ´ ÎÒÓÖÊÔ×ŰÑÒ»¸öºÜ³¤µÄXMLÊý¾ÝÏȷŵ½Êý¾Ý¿âÖÐ ½á¹ûǰ̨ÊÇÄܰÑËü¶Á³öÀ´ÁË ÎÒÏÖÔÚ²»ÖªµÀΪʲô»áÕâÑù Çó¸ßÊÖ¸øµãÒâ¼û ÆäÖдæxmlÊý¾ÝµÄÏîÎÒÓõÄÊÇCLOB
¹Ø×¢ÖÐ
ûÃ÷°×ÄãµÄÎÊÌ⣿
ÄãÒ»¿ªÊ¼²»Äܴ棬ºóÀ´¿ÉÒÔ´æÁË£¿ÄÇÄã²»ÄÜ´æµÄʱºò±¨Ê²Ã´´í°¡£¿
лл¥É쵀 ÎÒÃ÷°×ÁË~~~ÕæµÄºÜлл
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸ö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×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
·þÎñÆ÷ϵͳÊÇxp,Êý¾Ý¿âoracle10g£¬web·þÎñÆ÷ÊÇtomcat£¬Á¬½ÓÊý¾Ý¿âʱ±¨Á¬½Ó´íÎó£¬ÈçÏÂËùʾ£ºThe Network Adapter could not establish the connectionÒì³££¬oracle·þÎñºÍ¼àÌýÒѾÆðÀ´ÁË£¨¶øÇÒ¶¼ÊÇÕýÈ·µÄ£©¡£Êý¾Ý¿âjar ......