查看某个用户下所有表的记录数——精准版

declare

  v_row_count NUMBER;

begin

  for r in (select t.OWNER || '.' || t.TABLE_NAME TABLE_NAME
              from dba_tables t
             where t.OWNER = 'XXXX') LOOP
    EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || R.TABLE_NAME
      INTO V_ROW_COUNT;
    DBMS_OUTPUT.put_line(RPAD(R.TABLE_NAME, 60, ' ') || 'ROW_NUMBER IS ' ||
                         V_ROW_COUNT);
 
  END LOOP;

end;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24558043/viewspace-676587/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24558043/viewspace-676587/