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

On Thu, 17 Oct 2002, NOSPAM_at_thankyou.com wrote:
> 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.

I don't get it. Are you asking if Oracle can do inline views while also limiting the inline to a particular number of rows? The answer, yes.

Are you asking if Oracle can do ranking operations within a select? The answer, yes.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.