oracleÖÐTranslate()º¯ÊýÓ÷¨
Ò»¡¢Óï·¨£º
TRANSLATE(string,from_str,to_str)
¶þ¡¢Ä¿µÄ
·µ»Ø½«£¨ËùÓгöÏֵģ©from_strÖеÄÿ¸ö×Ö·ûÌ滻Ϊto_strÖеÄÏàÓ¦×Ö·ûÒÔºóµÄstring¡£TRANSLATEÊÇREPLACEËùÌṩµÄ¹¦ÄܵÄÒ»¸ö³¬¼¯¡£Èç¹ûfrom_str±È to_str³¤£¬ÄÇôÔÚfrom_strÖжø²»ÔÚto_strÖеĶîÍâ×Ö·û½«´ÓstringÖб»É¾³ý£¬ÒòΪËüÃÇûÓÐÏàÓ¦µÄÌæ»»×Ö·û¡£to_str²»ÄÜΪ¿Õ,Oracle½«¿Õ×Ö·û´®½âÊÍΪNULL£¬²¢ÇÒÈç¹ûTRANSLATEÖеÄÈκβÎÊýΪNULL£¬ÄÇô½á¹ûÒ²ÊÇNULL¡£
Èý¡¢ÔÊÐíʹÓõÄλÖÃ
¹ý³ÌÐÔÓï¾äºÍSQLÓï¾ä¡£
ËÄ¡¢Ê¾Àý
SELECT TRANSLATE('abcdefghij','abcdef','123456') from dual;
TRANSLATE
--------------
123456ghij
SELECT TRANSLATE('abcdefghij','abcdefghij','123456') from dual;
TRANSLATE
--------------
123456
select translate('smaspalae','as','s') from dual;
TRANSLATE
--------------
mspslse
select translate('smaspalae','s','as') from dual;
TRANSLATE
--------------
amaapalae
¿ÉÒÔ½«from_strÓëto_strÖеÄÿһ¸ö×Ö·û¶ÔÓ¦ÆðÀ´£¬ÓÃto_str×Ö·ûÈ¥Ìæ»»stringÖÐfrom_str¶ÔÓ¦µÄ×Ö·û£¬
ÀýÈçtranslate('smaspalae','as','s')ÓÃto_strÖеÄ's'È¥Ìæ»»'smaspalae'ÖÐfrom_str¶ÔÓ¦µÄ×Ö·û'a'£¬
to_strÖÐûÓÐ×Ö·ûÓëfrom_strÖÐ's'¶ÔÓ¦£¬¿ÉÒÔÀí½âΪto_str
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
oracle¼¸¸ö³£Óõļà¿ØÊÓͼ
oracle¼¸¸ö³£Óõļà¿ØÊÓͼ
v$processÊÓͼ:
v$processÊÓͼ°üº¬µ±Ç°ÏµÍ³oracleÔËÐеÄËùÓнø³ÌÐÅÏ¢¡£³£±»ÓÃÓÚ½«oracle»ò·þÎñ½ø³ÌµÄ²Ù×÷ϵͳ½ø³ÌIDÓëÊý¾Ý¿âsessionÖ®¼ä½¨Á¢ÁªÏµ¡£
³£ÓÃÁУº
ADDR£º½ø³Ì¶ÔÏóµØÖ·
......
ÔÎĵØÖ·£ºhttp://www.cnblogs.com/yf520gn/archive/2009/01/12/1374359.html
EXISTSµÄÖ´ÐÐÁ÷³Ì
select * from t1 where exists ( select null from t2 where y = x )
¿ÉÒÔÀí½âΪ:
for x in ( select * from t1 )
loop
if ( exists ( select null from ......
oracle£¨²âÊÔ»·¾³Îªoralce10g£©ÖУ¬ÈôΪͬһ¿âÖУ¬²éѯʱÓÚ±íÃûÇ°Ìí¼ÓÓû§Ãû¼´¿É¡£ ÈôΪ¿ç¿â´¦Àí£¬ÓÐÁ½ÖÖ·½·¨¡£
µÚÒ»ÖÖ·½·¨£¬ÓÃDB_link´¦Àí¡£¶øÆä²»×ãÖ®´¦Îª²»ÄܲÙ×Ý´ó×ֶΡ£ÈçϲÙ×÷£º
&nb ......