Question

在oracle里面怎么循环??

在oracle里面怎么循环 比如说用户表A里面有字段id name 1 阿三2 阿四3 啊五 怎么在oracle里面要求循环输出每行的name啊

Answer 1

declaresn varchar(50);beginfor i in 1..3 loopselect name into sn from A where id=i;dbms_output.put_line(sn);end loop;end;

Answer 2

begin for rec in (select id,name from A) loop dbms_output.putline(rec.name); end loop;end;

Answer 3

for c in select id from a loop select name from a where id=c.id;end loop;