Re: hierarchical query - returning a treewalked subset

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.

sm Received on Fri Nov 09 2007 - 14:32:14 CST