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: Tue, 06 Nov 2007 07:52:36 -0800
Message-ID: <1194364356.736760.82520@v3g2000hsg.googlegroups.com>


On Nov 6, 7:13 am, Steve Howard <stevedhow..._at_gmail.com> wrote:
> Are you asking that if Steve is the parent, and Abigail and Madeline
> are the children, that you also want to see Abigail if Madeline is
> selected?
>
> Steve
> / \
> / \
> | |
> Abigail Madeline

no. what im saying is... if somebody does a search to find rows matching "Mad%", and it finds one, i need to return not only that row but also Madeline's parent row (Steve). and if Steve has a parent, i need to return *that row* to. basically -- for a given name-criteria, i need to find *all* ancestors to an indefinite degree.

this is because the 3rd party app i am working with breaks if it comes across an orphaned row -- that is, if any rows reference a ParentID, i need to also have those parent-rows present. and if those parent-rows have parents, they need to be present... etc.

its like a reverse treewalk. but for a name-criteria search.

sm Received on Tue Nov 06 2007 - 09:52:36 CST

Original text of this message

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