如何在字符和数值类型的数字前后补零

字符类型:

select lpad('345',8,'0') from dual;

select rpad('345',8,'0') from daul;

数值类型:

select lpad(345,8,0) from dual;

select rpad(345,8,0) from daul;