Oracle SQL - Function LPAD function

Introduction

LPAD function makes a string a certain length by adding (padding) a specified set of characters to the left of the original string.

LPAD stands for "left pad."

The general format for this function is:

LPAD(string, length_to_make_string, what_to_add_to_left_of_string) 

Demo

SQL>
SQL>-- from  w  ww.  j  a va 2  s .  c  o  m
SQL> SELECT LPAD('test', 15, '.') FROM dual
  2