Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

RPAD() functions behavior is identical to that of LPAD(), the only difference being the padding side

SQL> SQL> SELECT   2     RPAD('ABC',6,'***') result1,   3     LPAD('ABC',4,'***') result2,   4     RPAD('ABC',2,'***') result3   5  FROM dual; RESULT RESU RE ------ ---- -- ABC*** *ABC AB