declare
--类型定义
cursor c_job
is
select invclasscode,invclassname from bd_invcl where forinvname='1';
--定义一个游标变量v_cinfo c_emp%ROWTYPE ,该类型为游标c_emp中的一行数据类型
c_row c_job%rowtype;
begin
for c_row in c_job loop
dbms_output.put_line('select * from bd_invcl where invclasscode like '''||c_row.invclasscode||'%''');
BEGIN
execute immediate 'select * from bd_invcl where invclasscode like '''||c_row.invclasscode||'%''';
commit;
END;
end loop;
end;
--类型定义
cursor c_job
is
select invclasscode,invclassname from bd_invcl where forinvname='1';
--定义一个游标变量v_cinfo c_emp%ROWTYPE ,该类型为游标c_emp中的一行数据类型
c_row c_job%rowtype;
begin
for c_row in c_job loop
dbms_output.put_line('select * from bd_invcl where invclasscode like '''||c_row.invclasscode||'%''');
BEGIN
execute immediate 'select * from bd_invcl where invclasscode like '''||c_row.invclasscode||'%''';
commit;
END;
end loop;
end;