[xquery-talk] Connect by Prior

[kumar]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://xquery.com/pipermail/talk/attachments/20060529/8728ee04/attachment.htm