Oracle PL/SQL Lpad Function

The Lpad function pads the left-side of a string with a specific set of characters.

The Lpad Function syntax:

lpad( text, length, [ pad_text ] )

Pad_text is optional, is the string that will be padded to the left-hand side of string.

Example:

select lpad('oracle', 7) from dual;
would return ' oracle'

select lpad('oracle', 3) from dual;
would return 'ora'

select lpad('oracle', 8,'0') from dual;
would return '00oracle'