SELECT RPAD('dcodeman',10,'*') FROM DUAL;

SELECT RPAD('dcodeman',10,'-') FROM DUAL;

SELECT RPAD('dcodeman',10,'*-*') FROM DUAL;

SELECT RPAD('dcodeman',2,'*') FROM DUAL;

SELECT RPAD('dcodeman',-2,'*') FROM DUAL;

SELECT RPAD('dcodeman',0,'*') FROM DUAL;

The 3rd parameter to RPAD is optional. When you don’t specify the 3rd parameter in RPAD, Oracle takes the default parameter as white space.

SELECT RPAD('dcodeman',10) FROM DUAL;

The 1st and 2nd parameter to RPAD are compulsory. If you don’t specify then Optimizer raises error i.e “ORA-00938: not enough arguments for function.“

SELECT RPAD('dcodeman') FROM DUAL;