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






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