Re: hierarchical query : how to return 'parent' of level 1 + current row ?

Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:<9sttfq0cha_at_drn.newsguy.com>...
> In article <11d4ca3.0111140306.10c86a63_at_posting.google.com>,
> vincent.pennec_at_cub-brest.fr says...
> >
> >Hi,
> >
> >Do you know how to return (*) for each row of a hierarchical query
> >PLUS the 'parent' of level 1 ?
> >
> >eg
> >grandparent_A
> > parent_A_A
> > child_A_A_A
> > child_A_A_B
> > parent_A_B
> > child_A_B_A
> >grandparent_B
> > parent_B_A
> > child_B_A_A
> >
> >would return
> >
> > * for each row + level 1
> >grandparent_A |...|...|... grandparent_A
> >parent_A_A |...|...|... grandparent_A
> >child_A_A_A |...|...|... grandparent_A
> >...
> >child_B_A_A |...|...|... grandparent_B
> >
> >Thanks,
> >
> >Vincent Pennec
>
> see
> http://groups.google.com/groups?q=sys_connect_by_path&hl=en&rnum=1&selm=994786401.8669.0.nnrp-07.9e984b29%40news.demon.co.uk
>
> if that URL doesn't work, search for
>
> sys_connect_by_path
>
> on google groups.

Thanks,

I found just what I need @
http://groups.google.com/groups?q=sys_connect_by_path&hl=en&rnum=2&selm=9jandv02gnr%40drn.newsguy.com

A 'simple' subquery -I must have found these one !-

Name of the poster of the thread was Vince (short for Vincent), funny no ?

Vincent Pennec Received on Thu Nov 15 2001 - 07:32:58 CST