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 question - grabbing everything related

Re: hierarchical question - grabbing everything related

From: SpaceMarine <spacemarine_at_mailinator.com>
Date: Wed, 07 Nov 2007 13:37:25 -0800
Message-ID: <1194471445.662836.85160@o38g2000hse.googlegroups.com>


On Nov 6, 10:18 am, SpaceMarine <spacemar..._at_mailinator.com> wrote:

> ...going to try that.

this doesnt quite work. while it works for simple examples, a childIDbased  rowset doesnt allow for more than one childID per parent, which is no good. damn.

very challenging.

i have 20,000 product rows, w/ varying levels of hierarchies. i want to do a name-based search to get a subset of them, but i want it to list all of the returned rows' descendants too. this should be pretty doable.... but how!? Received on Wed Nov 07 2007 - 15:37:25 CST

Original text of this message

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