Update a table column using a sequence

create table duplicate as select * from original
alter table duplicate add ID number;
create sequence seq1

set pagesize 0

set linesize 200

spool update.sql
select 'update duplicate set ID='||seq1.nextval||q'[ where rowid=']'||rowid||q'[';]' from duplicate;

spool off

>@update.sql