1、Oracle查询数据库中所有表的记录数，但是有可能不准建议用第二种方式进行查询
select t.table_name,t.num_rows from user_tables t
2、创建oracle函数，通过函数中查询词表记录数显示当前记录数
create or replace function count_rows(table_name in varchar2, owner in varchar2 default null) return number authid current_user IS num_rows number; stmt varchar2(2000); begin if owner is null then stmt := ‘select count(*) from "‘ || table_name || ‘"‘; else stmt := ‘select count(*) from "‘ || owner || ‘"."‘ || table_name || ‘"‘; end if; execute immediate stmt into num_rows; return num_rows; end;
之后执行：select table_name, count_rows(table_name) nrows from user_tables
就可以准确查询到记录数
原文：https://www.cnblogs.com/xiaoyu1994/p/10669519.html