Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: feature & performance comparison
in article B749727F.1536B%markbtownsend_at_home.com, Mark Townsend at markbtownsend_at_home.com wrote on 6/10/01 6:52 PM:
>> WITH RPL (PART, SUBPART, QUANTITY) AS
>> ( SELECT ROOT.PART, ROOT.SUBPART, ROOT.QUANTITY
>> FROM PARTLIST ROOT
>> WHERE ROOT.PART = '01'
>> UNION ALL
>> SELECT CHILD.PART, CHILD.SUBPART, CHILD.QUANTITY
>> FROM RPL PARENT, PARTLIST CHILD
>> WHERE PARENT.SUBPART = CHILD.PART
>> )
>> SELECT DISTINCT PART, SUBPART, QUANTITY
>> FROM RPL
>> ORDER BY PART, SUBPART, QUANTITY
Hmm - actually, there is more to this than I first saw - presumably this
iterates down through all levels of child ? How is this transformed ? Can
you push predicates into the traversal ? This may be way cool.
Received on Sun Jun 10 2001 - 21:30:02 CDT