|
|
Posted by Steve on 11/15/07 17:30
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
Navigation:
[Reply to this message]
|