declare cursor cur1 is select table_name from user_tables;
v_ename varchar2(40);
v_count int;
v_date date;
sql_stat varchar2(100);
begin
DBMS_OUTPUT.ENABLE(1000000);
open cur1;
loop
    fetch cur1 into v_ename;
    exit when cur1%notfound;
    sql_stat:= 'select count(*) from '|| v_ename;
    execute immediate sql_stat into v_count;
    dbms_output.put_line(v_ename||':'||v_count);
end loop;
close cur1;
end;

ITPub博客

oracle计算表的记录数

最新文章