我今天看见如下一段sql:
for c in(
select * from student t
where userid='000003')
loop
update test set id=c.id
where test.id='100001';
end loop;
commit;
我很困惑,这个C 应该就是临时表空间。可是执行,就是出错,请各位大侠指教!
for c in(
select * from student t
where userid='000003')
loop
update test set id=c.id
where test.id='100001';
end loop;
commit;
我很困惑,这个C 应该就是临时表空间。可是执行,就是出错,请各位大侠指教!
select id from student t
where userid='000003')
loop
update test set id=c.id
where test.id='100001';
end loop;
commit;