笨办法
declare
v_count number(10);
t_count number(10) default 0;
cursor t_cur is
select table_name
from user_tables;
begin
for t_rec in t_cur
loop
execute immediate 'select count(*) from '||t_rec.table_name||' into v_count';
t_count:=v_count+t_count;
end loop;
dbms_output.put_line(to_char(t_count));
end;