LPAD « Character String Functions « Oracle PL/SQL Tutorial

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 >