你做一个测试数据来测试一下不就行了?
cursor t_sor1 is select .........for v_sor1 in t_sor1 loop
for v_sor1 in 1..to_number(t_sor1.col_name) loop --这里把v_sor1换成别的.
...
end loop;
end loop;
cursor t_sor1 is select .........for v_sor1 in t_sor1 loop
for v_sor1 in 1..to_number(t_sor1.col_name) loop --这里把v_sor1换成别的.
...
end loop;
end loop;
谢谢大家
create or replace procedure PLableIssue
is
aa varchar2(100);
cursor c1 is select userid, id from t_user ;
begin
for r1 in c1
loop
for i in 1..to_number(r1.id)
loop
aa := r1.userid || ' ' || r1.id;
dbms_output.put_line(aa);
end loop;
end loop;
end PLableIssue;