tabel count

#database #sql #oracle

SELECT
t.owner || '.' || t.table_name AS full_table_name,
TO_NUMBER(EXTRACTVALUE(XMLTYPE(
DBMS_XMLGEN.GETXML('SELECT COUNT(*) c FROM ' || t.owner || '.' || t.table_name)), '/ROWSET/ROW/C')) AS row_count
FROM all_tables t
WHERE t.owner = 'YOUR_SCHEMA'
ORDER BY 1;