Oracle SQL - Function LPAD function

  1. HOME
  2. Oracle SQL
  3. Function
  4. 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  .jav a 2 s.c  o  m
SQL> SELECT LPAD('test', 15, '.') FROM dual
  2