右边补空格
select rpad(sysdate, 20, ' ') from dual
左边补空格
select lpad(sysdate, 20, ' ') from dual
右边补空格
select rpad(sysdate, 20, ' ') from dual
左边补空格
select lpad(sysdate, 20, ' ') from dual
转载于:https://www.cnblogs.com/libiao/archive/2009/02/16/1391250.html