Search This Blog

Google Analytics

Sunday, January 14, 2024

Oracle: Find out total number of records of all tables

An efficient method to find out the total record counts of all tables in an Oracle database.
select table_name,
  to_number(extractvalue(xmltype(dbms_xmlgen.getxml('select count(*) c from '||owner||'.'||table_name)),'/ROWSET/ROW/C')) as count
from all_tables
where owner = 'SchemaName';

Hope it helps.

No comments:

Post a Comment

Do provide your constructive comment. I appreciate that.

Popular Posts