고수님들 아래 문제 해결 부탁드립니다.ㅠ_ㅠ
[기본테이블]

LOT	NODE
A	B
B	C
C	D
D	E
E

결과
Search : A

ROOT	LOT
E	A
E	B
E	C
E	D
E	E

Search : B

ROOT	LOT
E	B
E	C
E	D
E	E

with a as
(
select 'A' LOT, 'B' NODE from dual
union all
select 'B' LOT, 'C' NODE from dual
union all
select 'C' LOT, 'D' NODE from dual
union all
select 'D' LOT, 'E' NODE from dual
union all
select 'E' LOT, '' NODE from dual

) select * from a;