orcal获得每个表的数据条数

plsql 直接点 file =》 new =》sql windows 


declare
    cursor c1 is select table_name from user_tables;
    sqlText      varchar(100);
    countNumber  varchar(100);
begin
 for mytable in c1 loop
     execute immediate 'select count(*) from '||mytable.table_name into countNumber;
     dbms_output.put_line(mytable.table_name||'      '||countNumber);
 end loop;

end;

如果内存溢出 修改Buffer size的值