在Oracle PL/SQL中游标声明中表名动态变化的方法
/* begin
.....
end getservicesname1;
An example:
create or replace procedure cal(tb varchar2) is
id pls_integer;
total pls_integer := 0;
type emp_cur is ref cursor;
cur emp_cur;
begin
open cur for 'select employee_id from ' || tb;
loop
fetch cur into id;
exit when cur%notfound;
total := total + id;
end loop;
close cur;
dbms_output.put_line(total)
end;*/
