oracle补零

1
2
3
4
5
6
---1.前端补0： 

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

---2.后端补0 
select rpad('345',8,'0') from dual;