Re: Automumber a field

Prachi wrote:
>
> I want to create a new table similar to an existing table
> I want to add one more column to this new table which should be
> autonumbered and has values randomly assigned to it.
> Then I want to tranfer all the data from the old table to this newly
> created table.
> How can I do it?

Follow the links to FAQ on www.jlcomp.demon.co.uk

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."