The number of records for all tables in the Oracle query database

first set up a computational function
>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>
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;
and then, by counting the functions ,
Select TABLE_NAME, COUNT_ROWS (table_name) nrows from User_tables

This article is from the "Technical Achievement Dream" blog, please be sure to keep this source http://pizibaidu.blog.51cto.com/1361909/1683502

The number of records for all tables in the Oracle query database