Re: hierarchical query - returning a treewalked subset

On Nov 9, 2:32 pm, SpaceMarine <spacemar..._at_mailinator.com> wrote:
> On Nov 9, 1:52 pm, DA Morgan <damor..._at_psoug.org> wrote:
>
> > Take any query that produces a result set in Oracle.
> > Wrap it with parentheses so it becomes an in-line view.
> > SELECT DISTINCT from it.
>
> while i havent tried that yet, my initial thought was that it wouldnt
> work -- because unique descendants of a duped-row would still be
> present, throwing off the LEVEL hierarchy / row order.

...but then again, it may, since that scenario could be impossible (if a row is duped, then its descendants would all be duped too, and wouldnt be unique any longer). will have to test it further when i get back.

sm Received on Fri Nov 09 2007 - 14:47:53 CST