我有一个表test1(id,loop) 里面的数字是不连续的,,我像把他们都输出,,
declare
v_id number;
v_value VARCHAR2(10);
v_count NUMBER;
begin
SELECT max(id) into v_count from test1;
begin
while v_count>0
loop
v_count := count-1;
dbms_output.put_line(v_count);
select id,value into v_id,v_value from test1 where id := v_count;
dbms_output.put_line(v_id);
dbms_output.put_line(v_value);
end loop;
end;
end;
请问用游标怎么遍历表test1,,并且把数据全部输出,,,我没有多少分了,,,,麻烦哪位高手帮我写一下,,谢谢
------解决方案--------------------
- SQL code
v_count := count-1;--你写错了,改过来试下 v_count := v_count-1;
------解决方案--------------------