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

oracleÊý¾Ý¿âͨ¹ýdblinkͬ²½Êý¾ÝÎÊÌâ - Oracle / ¿ª·¢

±³¾°£º
ÓÐÁ½¸öÊý¾Ý¿âAºÍBÐèÒª½»»»Êý¾Ý£¬ÔÚÊý¾Ý¿âAÖн¨Á¢dblinkµ½Êý¾Ý¿âB£¬²¢ÔÚÊý¾Ý¿âAÖн¨Á¢Êý¸öprocedure£¨ÓÃÓÚͬ²½Êý¾Ý£©£¬ÔÚunixÏÂʹÓÃshell½Å²½¶¨Ê±µ÷ÓÃprocedure¡£
ÍøÂç»·¾³£ºÊý¾Ý¿âBÊÇÍⵥλµÄ£¬ÓëÊý¾Ý¿âAËùÔÚµÄÍøÂçʹÓÃרÏßÁ¬½Ó

ÎÊÌ⣺
ÒòΪÊý¾Ý¿âBÊÇÍⵥλµÄ£¬Èç¶Ô·½Í£»úά»¤»òÕßÊÇÊý¾Ý¿â·¢Éúå´»ú£¬ÊÇ·ñ»áµ¼ÖÂÊý¾Ý¿âA³öÏÖ²»¿ÉÔ¤ÖªµÄÎÊÌ⣬ÈçËÀËø¡¢½ø³Ìhaltס£¿


¶Ô£¬°´ÕÕÂ¥ÉÏ˵µÄÓ¦¸ÃÎÊÌâ²»´ó£¡


ÒýÓÃ
ÏêϸµÄ¹ØÓÚ·Ö²¼Ê½ÊÂÎñµÄ˵Ã÷


·Ö²¼Ê½ÊÂÎñ£¿ µ«ÊǶԷ½µÄÊý¾Ý¿âÎÒÊÇÎÞ·¨¿ØÖƵÄ


Ïà¹ØÎÊ´ð£º

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

ÅäÖû·¾³±äÁ¿oracleÔÚ XP - Oracle / »ù´¡ºÍ¹ÜÀí

ÅäÖû·¾³±äÁ¿oracleÔÚ XP
 ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39 
ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ
»·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ.

XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿
¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......

ÎÊÒ»¸öoracle»ù´¡ÖªÊ¶ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÒª¸ñʽ»¯Êý×Ö1£¬ÎÒµÄλÊýÊÇÒ»¸ö±äÁ¿n£¬
 ÀýÈçn=3ʱ to_char(1,'FM099') ÎÒ²»ÖªµÀÔõôÓÃÄǸö±äÁ¿nÈ¥Ìæ»»ÄǼ¸¸ö9
û¿´¶® replaceô

ÊǵÄÒýÓÃ
û¿´¶® replaceô

replace('FM099','9','ÏëÌæ»»³Éµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ