Connect by Prior

This is a multi-part message in MIME format.

Hi All,

 

Below is the table structure which I am using with data.

 

create table prune_test (

  parent  number,

  child   number

);

insert into prune_test values (null,   1);

insert into prune_test values (null,   6);

insert into prune_test values (null,   7);

insert into prune_test values (   1,  12);

insert into prune_test values (   1,  14);

insert into prune_test values (   1,  15);

insert into prune_test values (   6,  61);

insert into prune_test values (   6,  63);

insert into prune_test values (   6,  65);

insert into prune_test values (   6,  69);

insert into prune_test values (   7,  71);

insert into prune_test values (   7,  74);

insert into prune_test values (  12, 120);

insert into prune_test values (  12, 124);

insert into prune_test values (  12, 127);

insert into prune_test values (  65, 653);

insert into prune_test values (  71, 712);

insert into prune_test values (  71, 713);

insert into prune_test values (  71, 715);

insert into prune_test values (  74, 744);

insert into prune_test values (  74, 746);

insert into prune_test values (  74, 748);

insert into prune_test values ( 712,7122);

insert into prune_test values ( 712,7125);

insert into prune_test values ( 712,7127);

insert into prune_test values ( 748,7481);

insert into prune_test values ( 748,7483);

insert into prune_test values ( 748,7487);

Below is the Connect by prior clause.

SELECT prune_test.* FROM prune_test        

START WITH prune_test = 14 

CONNECT BY PRIOR TERRITORY_LOOKUP_ID = PARENT_ID

 

I am currently using connect by prior clause for generating report.

 

I want to know is there any thing which can be done in xquery similar to “connect by prior”  

 

 

Thanks

Kumar