Oracle PL/SQL Rpad Function
The Rpad function pads the right-side of a string with a specific set of characters.
The Rpad Function syntax:
rpad( text, length, [ pad_text ] )
Pad_text is optional, is the string that will be padded to the right-hand side of string.
select rpad('forms', 6) from dual; would return 'forms ' select rpad('forms', 3) from dual; would return 'for' select rpad('report', 9,'0') from dual; would return 'report000'