Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: hierarchical query - returning a treewalked subset
SpaceMarine wrote:
> On Nov 9, 4:00 am, havardk <hrkristiansen..._at_hotmail.com> wrote:
>> Ah... Now I understand your problem. Avoiding duplicates complicates >> matters, because then you will have to traverse the tree the other way >> to see if any other candidate is listed higher, starting from all rows >> that satisfy your "start with" criteria. >> >> The select below is even slower, but still works for this problem. I >> suspect there is an easier way to solve this :-)
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.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Nov 09 2007 - 13:52:36 CST
![]() |
![]() |