Rpad – Oracle SQL Function

RPAD returns a VARCHAR2 string that is arg1 right padded with arg3 for a length of n.

If arg3 is not provided Oracle will pad with blank spaces.

Example:

SELECT RPAD(’10 + spaces’,10,’+’) as RESULT from dual;