数据库里查询多张表的数据量

需要查询多张表的里的数据量时

declare

v_sql varchar2(500);

v_count number(10);

begin

for v_tab in (select table_name from user_tables t where table_name like 'BASE_ORI%') loop

v_sql := 'select count(*) from '|| v_tab.table_name;

execute immediate v_sql into v_count;

dbms_output.put_line(v_tab.table_name||':'||v_count);

end loop;

end;

/