(1)左边填充
select lpad('abcde',10,'0') from dual;
结果:00000abcde
(2)右边填充
select rpad('abcde','0') from dual
结果:abcde00000