Number of data records for all tables in the Oracle statistics database SQL

1. Query table name:

SELECT table_name from User_all_tables;

2. Assemble statistical SQL statements:

1 >select ' SELECT ' | | table_name | | ' As TableName, COUNT (*) from ' | | table_name | | ‘ ; ' As Exectutesql from User_all_tables;

2> select ' Select ' | | table_name | | ' As TableName, COUNT (*) from ' | | table_name | | ' Union ' as exectutesql from User_all_tables;

3. Copy the assembled Exectutesql execution

select * from ( 第二步2> 执行的结果复制到这里 删除最后一个 union  )  执行

4. Look at the results of the query.

Number of data records for all tables in the Oracle statistics database SQL