Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: hierarchical query - returning a treewalked subset
On Thu, 08 Nov 2007 14:53:24 -0800, SpaceMarine
<spacemarine_at_mailinator.com> wrote:
>On Nov 8, 2:43 pm, Brian Tkatch <N/A> wrote:
>
>> >> Why does it not work? What error have you been getting?
>>
>> >it returns duplicate rows. the reason being (as far as i can tell), is
>> >that it first returns every product row that matches the name-criteria
>> >("test*") as a LEVEL 1; then, it digs up all children for each
>> >returned row and builds levels under them. this can provide for
>> >misleading duplicates because a product may be a LEVEL 3 child, yet is
>> >now also returned as a LEVEL 1 row, which it is truly not.
>>
>> >currently im having to re-loop the returned resultset, and remove any
>> >LEVEL 1 row that is also defined as a LEVEL 2+.
>>
>> >make sense?
>>
>> Perhaps the START WITH needs to be defined to choose only a level 1.
>
>nope.
>
>sm
Care to explain?
B. Received on Fri Nov 09 2007 - 08:14:04 CST