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

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.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp