Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚ£ºÍâÍø·ÃÎÊoracle·þÎñÆ÷µÄÎÊÌâ?


±¾»úÁ¬½Óoracle10gûÓÐÎÊÌ⣬Èç¹ûÍâÍøÁ¬½ÓÄÚÍøoracle10g·þÎñÆ÷Ó¦¸ÃÈçºÎµÄ×öÄØ£¿

ÍøÉϴ󲿷ֶ¼ÊÇÒÔÄÚÍøÓ³É䵽·ÓÉÆ÷Éϵ«ÊÇÎÒÏë²»Ã÷°×µÄÊÇ£¿ ÄǶ˿ÚÓ¦¸ÃÑ¡ÔñÄĸöÄØ£¿ 1521 »¹ÊÇ 5500ÄØ£¿

ÎÒʹÓõÄÊÇjdbc:oracle:thin:@202.106.195.30:1521:XXXX

Á¬½Ó·½Ê½¡£ÓÐÓ¦¸ÃÈçºÎÈ¥×öÄØ£¿

´ó²¿·ÖÈËȺ»áÑ¡Ôñ¿Í»§¶ËÈ¥×öÁ´½ÓÈçtoad pl/sqlµÈÖм乤¾ß£¬µ«ÊÇÎÒÖ»ÊdzÌÐòÉÏÔËÓô˷þÎñÆ÷Ö»ÐèÁ¬½Ó·þÎñÆ÷¾Í¿ÉÒÔÀ²£¡

ÎÒ²»ÖªµÀÕâ¸öURLµ½µ×Ôõôд£¿ Ò²²»ÖªµÀµ½µ×Ó¦¸ÃÔõô²¿Êð£¿

»¹ÓÐÎÒÊÇ·ñ¸úoracleWEB·þÎñÆ÷»·¾³ÓйØÏµ¡¢ÈÃÎÒºÃÃÔ㣬ÇëÖîλ¸ßÊֺʹóϺ¶¦Á¦ÏàÖú¡£

ÔÚÏ£¬¸Ð¼¤²»¼°¡£¡¢

ÈçÌ⣬»Ø´ð£¿
×Ô¼ºÏÈ×ö×Å¿´»á°É£¡

µ±È»ÊÇÍâÍøÄÇÌ«»úÆ÷ÉèÖÃµÄ ORACLE¶Ë¿ÚÁË¡£Ò»°ã1521.Ä㶼ûÊÔ¹ý

¹Ø×¢¡£


¾ÀÕý¸öÎÊÌâ,²»»á°ÑORACLE·þÎñÆ÷IPÖ±½Ó±©Â¶¸øÍâÍø,¶¼ÊÇͨ¹ý×öÓ³ÉäºÍת·¢

Ì«Éî°ÂÀ²¡£ÃÔºý¡£
ÄÜ˵µÄ¸üÏêϸһµãÂð

{{


Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸ö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·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

ÇóÖúÒ»¸ö¶¨Ê±Ö´ÐÐoracle´æ´¢¹ý³ÌµÄÎÊÌ⣬Çë´óÏÀ°ïæ

ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º
.....from table_name@cxdb_link
Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ