Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> For Those Who Know DB2 and Oracle, Can You Take A Look

For Those Who Know DB2 and Oracle, Can You Take A Look

From: dudes <NOSPAM_at_thankyou.com>
Date: Thu, 17 Oct 2002 23:54:26 GMT
Message-ID: <3DAF4DAD.6090203@thankyou.com> 





Does Oracle have anything similar to the following DB2 V6 query:




With RangeTable(CRank, CLow, CHigh) as


(


values (00, 0, 999)


union all


select CRank+1, CLow+1000, CHigh+1000 from RangeTable where CRank < 50
)




Apparently, this creates a 50 row result set which can then be used to 
join to a real table.  A guy in a DB2 newsgroup posted this in response 
to a question I had.  I didn't know DB2 had something this powerful.
Received on Thu Oct 17 2002 - 18:54:26 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US