|
|
Posted by Jerry Stuckle on 11/15/07 22:21
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.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|