蛋疼的方法。。。不知道真正跑起来要多久
比如我的表a 有30亿行现在要在a上加一列序号
首先
alter table a add(test_num number default 9999999999);
然后 写个循环
open c_number for
select ROWNUM from a;
loop
fetch c_number
into v_number;
--execute immediate 'insert into yang(test_num) values(s_num.nextval)';
execute immediate 'update a set test_num =' || v_number ||
'where ROWNUM=1 AND test_num=9999999999 ';
exit when c_number%notfound;
end loop;