LPAD « Character String Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Character String Functions
  3. LPAD
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 >