Re: hierarchical question - grabbing everything related

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 07 Nov 2007 17:38:07 -0800
Message-ID: <1194485882.331573@bubbleator.drizzle.com>

SpaceMarine wrote:
> On Nov 7, 4:15 pm, DA Morgan <damor..._at_psoug.org> wrote:
>

>>> 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!?
>> Given that you've chopped out previous posts the information that might
>> have helped answer that question is now gone.

>
> hows that? i dont believe in quoting entire threads endlessly; quoting
> should be limited & concise.
>
> further, the circumstances are exactly what ive stated -- 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. one doesnt need to see all the
> past posts to respond to that notion, especially since nothing else
> has worked.
>
> sm

And what is it that CONNECT BY doesn't do that you want?

PS: No some of us can not go back and review old posts. Don't assume that what you see is what we see.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Wed Nov 07 2007 - 19:38:07 CST