本人刚学oracle,菜鸟问题请谅解
这是我创建的表
create table lz(
id number(2),
name varchar2(10)
);
-------------------------------------
begin
for i in 1..10 loop
insert into lz values(i,'niit'||i);
end loop;
end;
/
commit;这个第二步
declare
cursor v_cur is select id,name from lz order by id ;
v_row lz%rowtype;
begin
open v_cur;
fetch v_cur into v_row;
while v_cur%found loop
dbms_output.put_line('id:'||v_row.id||'name:'||v_row.name);
fetch v_cur into v_row;
end loop;
close v_cur;
end;
/
下面是问题
begin
for hello in (select id,name from lz order by id DESC) loop
dbms_output.put_line('id:'||hello.id||'name:'||hello.name);
end loop;
end;
/
此处的hello改成任何一个都可以,和游标作用一样,为什么?????本人小白,请各位从简单说
这是我创建的表
create table lz(
id number(2),
name varchar2(10)
);
-------------------------------------
begin
for i in 1..10 loop
insert into lz values(i,'niit'||i);
end loop;
end;
/
commit;这个第二步
declare
cursor v_cur is select id,name from lz order by id ;
v_row lz%rowtype;
begin
open v_cur;
fetch v_cur into v_row;
while v_cur%found loop
dbms_output.put_line('id:'||v_row.id||'name:'||v_row.name);
fetch v_cur into v_row;
end loop;
close v_cur;
end;
/
下面是问题
begin
for hello in (select id,name from lz order by id DESC) loop
dbms_output.put_line('id:'||hello.id||'name:'||hello.name);
end loop;
end;
/
此处的hello改成任何一个都可以,和游标作用一样,为什么?????本人小白,请各位从简单说
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货