[xquery-talk] Connect by Prior
kumar
kumarpal.jain at infobeans.com
Mon May 29 21:08:15 PDT 2006
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
More information about the talk
mailing list