统计所有表的记录行数

declare    cnt number;begin    dbms_output.put_line(rpad('table_name',35)||rpad('records',20));    dbms_output.put_line(rpad('---------------',35)||rpad('--------------',20) );    for rec in(select table_name from user_tables order by table_name) loop        execute immediate 'select count(*) from '||rec.table_name into cnt;        dbms_output.put_line(rpad(lower(rec.table_name),35)||rpad(cnt,20));    end loop;end;/