¹þ¹þ£¬Ð»Ð»¸÷룬µ«ÊÇÎÒµÄSqlÓï¾äÊÇ select * from table where ..... Õâ¸öʱºò±íÖеÄ×Ö¶ÎÔõôÄܼÓÉÏtrimÄØ£¿ÎÒ²»¿ÉÄܰѱíÄÚµÄËùÓÐ×ֶζ¼ÄóöÀ´¼ÓÉÏtrimµÄ Äǿ϶¨ÊÇûÓÐʲôºÃ°ì·¨
»òÕßÄã¿ÉÒÔÔÚinsert intoÖ®ºóÔÙÒ»´ÎÐÔÖ´ÐÐupdate newtable set varcharcol = trim(varcharcol); лл£¬ÎÒÈ¥ÊÔÊÔ£¡
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......