¹ØÓÚ£ºÍâÍø·ÃÎÊoracle·þÎñÆ÷µÄÎÊÌâ?
±¾»úÁ¬½Óoracle10gûÓÐÎÊÌ⣬Èç¹ûÍâÍøÁ¬½ÓÄÚÍøoracle10g·þÎñÆ÷Ó¦¸ÃÈçºÎµÄ×öÄØ£¿
ÍøÉϴ󲿷ֶ¼ÊÇÒÔÄÚÍøÓ³É䵽·ÓÉÆ÷Éϵ«ÊÇÎÒÏë²»Ã÷°×µÄÊÇ£¿ ÄǶ˿ÚÓ¦¸ÃÑ¡ÔñÄĸöÄØ£¿ 1521 »¹ÊÇ 5500ÄØ£¿
ÎÒʹÓõÄÊÇjdbc:oracle:thin:@202.106.195.30:1521:XXXX
Á¬½Ó·½Ê½¡£ÓÐÓ¦¸ÃÈçºÎÈ¥×öÄØ£¿
´ó²¿·ÖÈËȺ»áÑ¡Ôñ¿Í»§¶ËÈ¥×öÁ´½ÓÈçtoad pl/sqlµÈÖм乤¾ß£¬µ«ÊÇÎÒÖ»ÊdzÌÐòÉÏÔËÓô˷þÎñÆ÷Ö»ÐèÁ¬½Ó·þÎñÆ÷¾Í¿ÉÒÔÀ²£¡
ÎÒ²»ÖªµÀÕâ¸öURLµ½µ×Ôõôд£¿ Ò²²»ÖªµÀµ½µ×Ó¦¸ÃÔõô²¿Êð£¿
»¹ÓÐÎÒÊÇ·ñ¸úoracleWEB·þÎñÆ÷»·¾³ÓйØÏµ¡¢ÈÃÎÒºÃÃÔ㣬ÇëÖîλ¸ßÊֺʹóϺ¶¦Á¦ÏàÖú¡£
ÔÚÏ£¬¸Ð¼¤²»¼°¡£¡¢
ÈçÌ⣬»Ø´ð£¿
×Ô¼ºÏÈ×ö×Å¿´»á°É£¡
µ±È»ÊÇÍâÍøÄÇÌ«»úÆ÷ÉèÖÃµÄ ORACLE¶Ë¿ÚÁË¡£Ò»°ã1521.Ä㶼ûÊÔ¹ý
¹Ø×¢¡£
¾ÀÕý¸öÎÊÌâ,²»»á°ÑORACLE·þÎñÆ÷IPÖ±½Ó±©Â¶¸øÍâÍø,¶¼ÊÇͨ¹ý×öÓ³ÉäºÍת·¢
Ì«Éî°ÂÀ²¡£ÃÔºý¡£
ÄÜ˵µÄ¸üÏêϸһµãÂð
{{
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
±¾À´ÒªÐ´¸ö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µÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º
.....from table_name@cxdb_link
Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......