写个存储过程吧 decare name var(20) SELECT table_name as name FROM dba_tables WHERE owner = 'username'; sum(select count(*) from $table_name)大概就是这样,应该是要用到游标,可惜我不熟,看有仁兄来不全不
笨办法 declare v_count number(10); t_count number(10) default 0; cursor t_cur is select table_name from user_tables; begin for t_rec in t_cur loop execute immediate 'select count(*) from '||t_rec.table_name||' into v_count'; t_count:=v_count+t_count; end loop; dbms_output.put_line(to_char(t_count)); end;
SELECT sum(num_rows) FROM user_tables;
就是把那个用户下所有的表导出来,看导出的记录信息。
exp一下,还有别的方法吗?
decare name var(20)
SELECT table_name as name FROM dba_tables WHERE owner = 'username';
sum(select count(*) from $table_name)大概就是这样,应该是要用到游标,可惜我不熟,看有仁兄来不全不
declare
v_count number(10);
t_count number(10) default 0;
cursor t_cur is
select table_name
from user_tables;
begin
for t_rec in t_cur
loop
execute immediate 'select count(*) from '||t_rec.table_name||' into v_count';
t_count:=v_count+t_count;
end loop;
dbms_output.put_line(to_char(t_count));
end;