查询数据中所有表实际记录数

时间：2014-03-25 22:35:30 收藏：0 阅读：475

set serverout on
set serveroutput on size 1000000
declare
v_tab_name varchar2(100);
cursor empCur is  select table_name from user_tables where table_name like ‘PUB%‘;
n_lows number;
v_sql varchar2(1000);
begin
  open empCur;
  
   loop
    fetch empCur into v_tab_name;
    v_sql:=‘select count(1) from ‘||v_tab_name;
    execute immediate v_sql into n_lows;
    exit when empCur%notfound; 
     DBMS_OUTPUT.PUT_LINE(v_tab_name||‘,‘||n_lows);
   end loop;
    commit;
  close empCur; 
end;

查询数据中所有表实际记录数,布布扣,bubuko.com

原文：http://blog.csdn.net/lnwf5188588/article/details/22080309