oracleÊý¾Ý¿âͨ¹ýdblinkͬ²½Êý¾ÝÎÊÌâ - Oracle / ¿ª·¢
±³¾°£º ÓÐÁ½¸öÊý¾Ý¿âAºÍBÐèÒª½»»»Êý¾Ý£¬ÔÚÊý¾Ý¿âAÖн¨Á¢dblinkµ½Êý¾Ý¿âB£¬²¢ÔÚÊý¾Ý¿âAÖн¨Á¢Êý¸öprocedure£¨ÓÃÓÚͬ²½Êý¾Ý£©£¬ÔÚunixÏÂʹÓÃshell½Å²½¶¨Ê±µ÷ÓÃprocedure¡£ ÍøÂç»·¾³£ºÊý¾Ý¿âBÊÇÍⵥλµÄ£¬ÓëÊý¾Ý¿âAËùÔÚµÄÍøÂçʹÓÃרÏßÁ¬½Ó ÎÊÌ⣺ ÒòΪÊý¾Ý¿âBÊÇÍⵥλµÄ£¬Èç¶Ô·½Í£»úά»¤»òÕßÊÇÊý¾Ý¿â·¢Éúå´»ú£¬ÊÇ·ñ»áµ¼ÖÂÊý¾Ý¿âA³öÏÖ²»¿ÉÔ¤ÖªµÄÎÊÌ⣬ÈçËÀËø¡¢½ø³Ìhaltס£¿
¶Ô£¬°´ÕÕÂ¥ÉÏ˵µÄÓ¦¸ÃÎÊÌâ²»´ó£¡ÒýÓà ÏêϸµÄ¹ØÓÚ·Ö²¼Ê½ÊÂÎñµÄ˵Ã÷ ·Ö²¼Ê½ÊÂÎñ£¿ µ«ÊǶԷ½µÄÊý¾Ý¿âÎÒÊÇÎÞ·¨¿ØÖƵÄ
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
ÅäÖû·¾³±äÁ¿oracleÔÚ XP ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39 ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ »·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ. XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿ ¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......
ÎÒÒª¸ñʽ»¯Êý×Ö1£¬ÎÒµÄλÊýÊÇÒ»¸ö±äÁ¿n£¬ ÀýÈçn=3ʱ to_char(1,'FM099') ÎÒ²»ÖªµÀÔõôÓÃÄǸö±äÁ¿nÈ¥Ìæ»»ÄǼ¸¸ö9 û¿´¶® replaceô ÊǵÄÒýÓà û¿´¶® replaceô replace('FM099','9','ÏëÌæ»»³Éµ ......