Let say I have a table with data like this:
id id2 id3
Now What I want to do is update the id column with a sequance(start from 1). I know I could write a trigger on this table but my question is I'm not updatating anything else in within the procedure only the id column. So I am not sure I could do this within a procedure. How can I achive this?
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.
for rec in
(select id from test)
update test set id=testseq.nextval