Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: hierarchical question - grabbing everything related
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