|
-
Hi,
Please user the following simple block, I have created test table having id columns as you have mentioned and also testseq sequence. Block was able to change the id with the sequence numbers.
I have tested this block and working fine.
begin
for rec in
(select id from test)
loop
update test set id=testseq.nextval
where id=rec.id;
commit;
end loop;
end;
Dilesh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|