Query to find the record count of table -- Oracle Apps

create or replace
function get_records( p_tname in varchar2 ) return number
as
    l_colval  number default NULL;
begin
    execute immediate
       'select count(*)
          from ' || p_tname INTO l_colval;

    return l_colval;
end;


Ex: 1. select
user, table_name,
       get_records(table_name) cnt
  from
user_tables
 
2. select
user, TNAME,
       get_records(TNAME) cnt
  from
R12_TABLES