select lpad( '*', 5, '*' ) : LPAD « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. LPAD

select lpad( '*', 5, '*' )

  
SQL>
SQL> select lpad( '*', 5, '*' )
  2  from dual;
LPAD(
-----
*****

1 row selected.

SQL> --








Related examples in the same category

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.Demo LEVEL inside of LPAD
5.Demo LEVEL inside of LPAD with '*'
6.Padding based on value length