Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to generate a randomized "seqno" column

Re: how to generate a randomized "seqno" column

From: Cris <cris119_at_operamail.com>
Date: Fri, 20 Oct 2006 09:38:21 +0200
Message-ID: <45387cf4$0$989$5fc30a8@news.tiscali.it>


Michel Cadot wrote:

> SQL> select id,

> 2 row_number() over (order by dbms_random.value) seqno
> 3 from t
> 4 order by id
> 5 /

Great! Thank you.

-- 
spamto:cris119_at_operamail.com

blind faith in your leaders or
in anything will get you killed
Received on Fri Oct 20 2006 - 02:38:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US