°ïæ½âÊÍÒ»ÌõSQLÓï¾ä
SQL code: SQL> select translate('a39as78900d0123456789d','0123456789','') from dual; T - Ϊʲô½á¹û²»ÊÇ£º REPLA ----- aasdd
Ò»¡¢Óï·¨£º 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Óï¾ä¡£ ÎÊÌâ¾ÍÔÚ£º to_str ²»ÄÜΪ¿Õ¡£Oracle ½«¿Õ×Ö·û´®½âÊÍΪ NULL£¬²¢ÇÒÈç¹ûTRANSLATE ÖеÄÈκβÎÊýΪNULL£¬ÄÇô½á¹ûÒ²ÊÇ NULL¡£ ÒýÓà SQL> select replace(translate('a39as78900d0123456789d','0123456789',' '),' ','') from dual; REPLACE(TR ---------- aasdd ºÇºÇ£¬·Ç³£¸Ðл¡£
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼: Àý£º
......
sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª: sldkf|||sdeww erkv|||rltdk jemcl|||ligf ¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð» ÔÎ µ ......
sqlÎÒÏëµÃµ½Ò»×Ö·û´®Îª: sldkf|||sdeww erkv|||rltdk jemcl|||ligf ¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð» ÔνñÌì²»ÊÇдÁËô select parsen ......
CREATE PROCEDURE [selectvipcompany] @username varchar(50), @companyname varchar(50), @endtime varchar(1) AS declare @sql varchar(1000) set @sql='' if (@username<>null and @username ......
CREATE PROCEDURE [selectvipcompany] @username varchar(50), @companyname varchar(50), @endtime varchar(1) AS declare @sql varchar(1000) set @sql='' ......