Demo LEVEL inside of LPAD with '*' : LPAD « Char Functions « Oracle PL / SQL






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

Demo LEVEL inside of LPAD with '*'

  

create table employee(
         emp_no                 integer         primary key
        ,lastname               varchar2(20)    not null
        ,mgr                    integer
);

insert into employee(emp_no,lastname,mgr)
              values(1,'Tomy',2);

insert into employee(emp_no,lastname,mgr)
              values(2,'Jacky',3);

insert into employee(emp_no,lastname,mgr)
              values(3,'Joey',4);

insert into employee(emp_no,lastname,mgr)
              values(4,'Janey',5);


col name format a20

select lpad('*',level, '*') || lastname as name
from employee
start with emp_no = 2
connect by prior emp_no = mgr;


NAME                
--------------------
*Jacky              
**Tomy          


drop table employee;








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.select lpad( '*', 5, '*' )
5.Demo LEVEL inside of LPAD
6.Padding based on value length