LPAD « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. LPAD
1.Lpad: makes a string a certain length by adding (padding) a specified set of characters to the left of the original string
2.If the character to be padded is longer than the requested total length, it will be trimmed to the exact total.
3.LPAD(string, 10,'*')
4.select lpad( '*', 5, '*' )
5.Demo LEVEL inside of LPAD
6.Demo LEVEL inside of LPAD with '*'
7.Padding based on value length