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>--   w  w  w . ja  va2s.c  o m
SQL> SELECT LPAD('test', 15, '.') FROM dual
  2