oracle計算表的記錄數

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;