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;
|