-- Example to traverse Tree using Oracle PL/SQLs
with table01
as(
select 1 field01, 2 field02 from dual Union all
select 2 field01, 3 field02 from dual Union all
select 3 field01, 4 field02 from dual Union all
select 4 field01, 5 field02 from dual Union all
select 100 field01, 101 field02 from dual Union all
select 101 field01, 102 field02 from dual Union all
select 101 field01, 103 field02 from dual Union all
select 103 field01, 104 field02 from dual Union all
select 103 field01, 105 field02 from dual Union all
select 105 field01, 106 field02 from dual
) select connect_by_root field01 field03, sys_connect_by_path( field02, '->' ) field04, field02 from table01
connect by prior field02 = field01
Friday, September 19, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment