--查询SCOTT用户中所有表的记录数
declare
v_count number;
query varchar2(4000);
begin
for i in (select table_name
from all_tables
where owner = 'SCOTT'
order by 1) loop
query := 'select count(*) from "' || i.table_name || '"';
execute immediate query
into v_count;
dbms_output.put_line(rpad(i.table_name, 35, ' ') || '-----' || v_count);
end loop;
end;
--查看分区表的行数
declare
v_count number;
query varchar2(4000);
begin
for i in (select table_name,partition_name
from user_tab_partitions
where table_name='DDM_TRANSACTION_LOG'
order by 1) loop
query := 'select count(*) from ' || i.table_name || ' partition(' || i.partition_name || ')' || '';
execute immediate query
into v_count;
dbms_output.put_line(rpad(i.partition_name, 35, ' ') || '-----' || v_count);
end loop;
end;
declare
v_count number;
query varchar2(4000);
begin
for i in (select table_name
from all_tables
where owner = 'SCOTT'
order by 1) loop
query := 'select count(*) from "' || i.table_name || '"';
execute immediate query
into v_count;
dbms_output.put_line(rpad(i.table_name, 35, ' ') || '-----' || v_count);
end loop;
end;
--查看分区表的行数
declare
v_count number;
query varchar2(4000);
begin
for i in (select table_name,partition_name
from user_tab_partitions
where table_name='DDM_TRANSACTION_LOG'
order by 1) loop
query := 'select count(*) from ' || i.table_name || ' partition(' || i.partition_name || ')' || '';
execute immediate query
into v_count;
dbms_output.put_line(rpad(i.partition_name, 35, ' ') || '-----' || v_count);
end loop;
end;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26506993/viewspace-1814771/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26506993/viewspace-1814771/