Galen Boyer wrote:
> 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.
No, what I was asking was whether Oracle allows you to create a result
set in SQL. I know you can do it in PL/SQL but I'm interested in a pure
SQL solution.
Received on Fri Oct 18 2002 - 05:55:18 CDT
