ÇëÎÊoracle¾«Í¨ÊǸöʲô¸ÅÄ
ÈçÌ⣬ÎÒºÜÏëÖªµÀ¾¿¾¹Ê²Ã´ÑùµÄ¾³½ç¾ÍË㾫ͨ£¿ÓÐÄÄЩ¾ßÌåµÄ£¬¿É²âµÄÖ¸±êÄܹ»²âÊÔµ½µ×ÊDz»ÊǾ«Í¨°¡£¿Ò»Ö±ºÜÀ§»ó
¡£¾³£¿´µ½ÕÐÆ¸ÐÅÏ¢ÉÏ XXX ¾«Í¨£¬XXX¾«Í¨¡£µ«ÊÇÕæµÄ¸ã²»Çå³þËûÃÇ˵µÄ¾«Í¨ÊǸöʲô¸ÅÄÄÇЩ¾«Í¨µÄ´óϺÃÇ£¬Äܲ»ÄÜ̸϶Ծ«Í¨µÄÀí½âºÍ¸ÐÊܰ¡£¿
àÅÎÒÒ²ÏëÖªµÀ
oracle¾«Í¨ÓеãÁýͳ£¬ÊÇ¿ª·¢¾«Í¨»¹ÊǹÜÀí¾«Í¨ÄØ£¬»¹ÊÇERP·½Ã棬
²»¹ý²»¹ÜÊÇ¿ª·¢»¹ÊǹÜÀí£¬¶¼Òª·Ç³£ÊìϤµ÷ÓÅ£¬Õâ¿ÉÊÇÎÒѪµÄ½ÌѵÀ²£¬¡Ñ﹏¡Ñb
ר¼Ò...
Ò»°ãÕæÕý¾«Í¨µÄÈ˲»¸Ò˵×Ô¼º¾«Í¨
UP
µ÷ÓÅ
¶Ô,µ÷Óŷdz£¹Ø¼ü.Óл·¾³×ö´óÁ¿²âÊÔÒ²ÊǺÜÖØÒªµÄ,Ö»ÓÐʵ¼ÊÔËÓõ½´óÁ¿Êý¾Ý,²Å¸üºÃȥѧϰ´¦Àí´óÁ¿Êý¾ÝµÄµ÷ÓÅ!
ÎҸоõÒ²¾ÍÊÇÓöµ½ÎÊÌâµÄºó£¬¿ÉÒÔ¾¡¿ì½â¾öÎÊÌ⣬²¢ÇÒ½â¾öÊֶαȽϺÏÀí°É¡£
¸ÕÈëÃÅ£¬ ÃþË÷ÖÐ..
²ËÄñÀ´¹ÛÍûһϡ£¡£¡£¡£¡£¡£¡£¡£¡£
ԽѧԽ¸Ðµ½×Ô¼º²»¶®µÄÌ«¶àÁË
hehe,oracle²©´ó¾«Éî~
Ö»Óпª·¢OracleµÄÈ˲ŸÒ˵ÕâÁ½¸ö×Ö°É...
ºÇºÇ ¿ª·¢ORACLEµÄÈËÒ²²»¸Ò˵°¡
ORACLEÓÖ²»ÊÇÒ»¸öÈË¿ª·¢³öÀ´µÄ
ij¸öÈ˶¥¶à²ÎÓ뿪·¢ÆäÖÐijһ²¿·Ö¶øÒÑ
OracleÌ«¸´ÔÓµÄÌåϵÁË£¬×¨ÓÚµ¥¸ö·½Ã滹¿ÉÒÔ×öµ½ÊìÁ·ºÍ¾«Í¨£¬ÒªÈ«Ãæ¾ÍÌ«ÄÑß·¡£
¸÷룬ÇëÎʵ÷ÓÅÊÇɶ¸ÅÄÊÇÖ¸Ö´ÐÐSQLÓÅ»¯£¬»¹ÊÇÊý¾Ý¿â¿Õ¼äÓÅ»¯£¿ÓÖ»òÕßÊÇÆäËû£¿
Ó¦¸Ã¶¼°üÀ¨
¸÷·½Ãæ¡£Ö»ÒªÈÃÐÔÄܸüºÃ Ó¦¸Ã¶¼Ëã°É
oracle²©´ó¾«Éîѽ¡£¡£¡£¡£¡£
Á˽âÁË£¬
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐ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 ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÏÖÔÚÎÒ±¾µØÃ»Óа²×°oracle, µ«plsqldevÐèÒªsqlplus.exeµÈ£¬ÇëÎÊoracle10gÔÚwindowsÐèÒª
ÄÄЩexeÎļþ£¬ÄÄλ´ó¸çÄÜ˳±ãÌṩһÏÂQQ£º190565390
×°oracleµÄʱºò¿ÉÒÔÑ¡ÔñÖ»×°¿Í»§¶ËµÄ
×îÆðÂëҪװoracle£¬ÄãÖ»Ðè×°¿ ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......