¹þ¹þ£¬Ð»Ð»¸÷룬µ«ÊÇÎÒµÄSqlÓï¾äÊÇ select * from table where ..... Õâ¸öʱºò±íÖеÄ×Ö¶ÎÔõôÄܼÓÉÏtrimÄØ£¿ÎÒ²»¿ÉÄܰѱíÄÚµÄËùÓÐ×ֶζ¼ÄóöÀ´¼ÓÉÏtrimµÄ Äǿ϶¨ÊÇûÓÐʲôºÃ°ì·¨
»òÕßÄã¿ÉÒÔÔÚinsert intoÖ®ºóÔÙÒ»´ÎÐÔÖ´ÐÐupdate newtable set varcharcol = trim(varcharcol); лл£¬ÎÒÈ¥ÊÔÊÔ£¡
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......