Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: hierarchical query - returning a treewalked subset

Re: hierarchical query - returning a treewalked subset

From: SpaceMarine <spacemarine_at_mailinator.com>
Date: Fri, 09 Nov 2007 08:47:20 -0800
Message-ID: <1194626840.381440.70960@k79g2000hse.googlegroups.com>


On Nov 9, 8:14 am, Brian Tkatch <N/A> wrote:

> >> Perhaps the START WITH needs to be defined to choose only a level 1.
>
> >nope.
>
> >sm
>
> Care to explain?

just didnt work, no difference in resultsets. i think this is because putting a level-1 on the START WITH is redundant -- all rows that it starts with are automatically assigned to level-1.

sm Received on Fri Nov 09 2007 - 10:47:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US