Lpad – Oracle SQL Function

LPAD returns a VARCHAR2 string that is arg1 left padded with arg3 for a length of n.

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

Example:

SELECT LPAD(’10 + signs’,10,’+’) as RESULT from DUAL;

RESULT
——————
++++++++++10 + signs