1. analyze you table 2. select * from user_tables where table_name='';
用sqlplus可能不能一次得到结果。 sql> set heading off sql> set echo off sql> set feedback off sql> set lines 200 sql> set pages 0 sql> spool gettabrows.sql sql> select 'select count(*) from '|| table_name ||';' from user_tables; sql> spool off sql> set echo on sql> set heading on sql> set lines 200 sql> @gettabrows.sql
用下面的select可能更好一些。 select 'select ' || '''' || table_name || '''' || ',(select count(*) from '|| table_name || ') from dual;' from user_tables
2. select * from user_tables where table_name='';
sql> set heading off
sql> set echo off
sql> set feedback off
sql> set lines 200
sql> set pages 0
sql> spool gettabrows.sql
sql> select 'select count(*) from '|| table_name ||';' from user_tables;
sql> spool off
sql> set echo on
sql> set heading on
sql> set lines 200
sql> @gettabrows.sql
select 'select ' || '''' || table_name || '''' || ',(select count(*) from '|| table_name || ') from dual;' from user_tables