This Oracle tutorial explains how to use the Oracle/PLSQL LPAD function with syntax and examples. The Oracle/PLSQL LPAD function pads the left-side of a string with a specific set of characters (when string1 is not null). The syntax for the LPAD function in Oracle/PLSQL is: