Number of records for all tables in Oracle query database

Select T.table_name,t.num_rows from User_tables t

If the above SQL is not found, execute the following script:
>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>
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
<<<<<<<<<<<<<<<<<<<<<<<<<<< <<<<<<<<<<<<<<<<<<<<<<<<<<< <<<<<<

Then check the Select TABLE_NAME, COUNT_ROWS (table_name) nrows from User_tables, OK