Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to generate a randomized "seqno" column
Michel Cadot wrote:
> SQL> select id,> 3 from t
> 2 row_number() over (order by dbms_random.value) seqno
Great! Thank you.
-- spamto:cris119_at_operamail.com blind faith in your leaders or in anything will get you killedReceived on Fri Oct 20 2006 - 02:38:21 CDT