ERIZHU的博客

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

sqlplus sys sys as sysdba alter user test account unlock; commit;