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.
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.