关于存储过程里COUNT总数
czb 2004-12-31 07:11:49 create or replace procedure testproc005 as
l_count number;
l_sql varchar2(1024);
begin
l_sql:='select count(*) into l_count from aaatbl';
dbms_output.put_line('l_sql='||l_sql);
execute immediate l_sql; --这句执行不成功
dbms_output.put_line(to_char(l_count));
commit;
end;
如何才能count到aaatbl'的总数?
注:不能直接调用select count(*) into l_count from aaatbl。