ERIZHU的博客

SELECT  RTRIM('0  00 00  12120 00','0') FROM DUAL  -- 0  00 00  12120SELECT  LTRIM('0  00 00  12120 00','0') FROM DUAL --  00 00  12120 00SELECT  REPLACE（TRIM('0  00 00  12120 00 '),' ','') FROM D

sqlplussyssys as sysdbaalter user test account unlock;commit;