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.

Example

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'