Find employee's manager and create a columns

Question

My input table looks like this

Employee	Manager
rahul	aria
aria	priya
priya	sheela
vasant	reema
reema	carol
guha	reeye

This is the output I want

Employee	Manager 1	Manager 2	Manager 3
rahul	aria	priya	sheela
vasant	reema	carol
guha	reeya

How can I achieve this? I tried until I can make it to the only manager, but not sure how to build columns as manager-employee relationship goes on

Answer 1

You can use SQL hierarchy query to retrieve :

    with tabletest as 
(
select 
'rahul' employee , 'aria' as manager from dual
union 
select 
'aria' as employee, 'priya' as manager from dual
union 
select
'priya' as employee, 'sheela' as manager from dual
)

select level, a.employee, Sys_Connect_By_Path(a.manager,'/') as path from tabletest a
connect by prior a.employee = a.manager;

enter image description here