Lpad makes a string a certain length by adding (padding) a specified set of characters to the left of the original string : LPAD « Character String Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Character String Functions
  3. LPAD

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)

SQL>
SQL>
SQL> SELECT LPAD('Column', 15, '.') FROM dual;

LPAD('COLUMN',1
---------------
.........Column

SQL>








11.11.LPAD
11.11.1.LPAD(x, width [, pad_string]) pads x with spaces to left to bring the total length of the string up to width characters.
11.11.2.Lpad makes a string a certain length by adding (padding) a specified set of characters to the left of the original string
11.11.3.LPAD() with number column
11.11.4.left padding the name of department
11.11.5.Padding based on value length
11.11.6.Padding department with < and >