Re: feature & performance comparison

From: Blair Kenneth Adamache <adamache_at_ca.ibm.com>
Date: Sun, 10 Jun 2001 21:11:44 -0400
Message-ID: <3B241AD0.A760206E@ca.ibm.com>

It starts with a Common Table Expression (the WITH):

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 Mark Townsend wrote:

> in article 3B2266AA.13D8BF0E_at_ca.ibm.com, Blair Kenneth Adamache at
> adamache_at_ca.ibm.com wrote on 6/9/01 11:10 AM:
>
> > Does Oracle have recursive SQL?
>
> I'm not exactly sure what you mean by recursive SQL - do you have an example
> ? Oracle does have some extensions for tree traversal - CONNECT BY - but I'm
> not sure this is what you mean.
Received on Sun Jun 10 2001 - 20:11:44 CDT