Posted by Steve on 11/15/07 22:51

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:67ydnT9pOvUSW6HanZ2dnUVZ_vzinZ2d@comcast.com...
> Steve wrote:
>> i know i know...just get over it. look at the date of the last
>> post/response in an oracle ng. :)
>>
>> this is a mysql specific query. i want to do the same thing in oracle. i
>> don't know how. the following gives a dynamic/unique id number to a set
>> of selected records. it kind of mimics RANK() in oracle. it's based on a
>> cartesian...anyway, if anyone can fill me in on a similar oracle
>> translation to this mysql query, i'd just about break down and cry from
>> joi.
>>
>> tia
>>
>> =============
>>
>> SELECT @id := @id + 1 Id ,
>> Value
>> FROM
>> (
>> SELECT @id := 0
>> ) uniqueId ,
>> (
>> SELECT 'ABC' Value
>> UNION
>> SELECT 'DEF' Value
>> UNION
>> SELECT 'GHI' Value
>> ) pseudoTable
>
> Steve,
>
> comp.databases.oracle.server seems to have quite a bit of traffic.

thanks jerry...i didn't see that one listed. i'll give it a shout.

thanks again.

[Back to original message]