Get counts of all tables in a schema

by

This can be done with a single statement and some XML magic:

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="FOOBAR"

More Related Contents:

  1. What is the replacement of cursor foreach in oracle pl/sql?
  2. Can you SELECT everything, but 1 or 2 fields, without writer’s cramp?
  3. PL/SQL, how to escape single quote in a string?
  4. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  5. Passing an array of data as an input parameter to an Oracle procedure
  6. Get resultset from oracle stored procedure
  7. Oracle PL/SQL – How to create a simple array variable?
  8. ways to avoid global temp tables in oracle
  9. Split function in oracle to comma separated values with automatic sequence
  10. ORA-06508: PL/SQL: could not find program unit being called
  11. Number of rows affected by an UPDATE in PL/SQL
  12. PL/SQL print out ref cursor returned by a stored procedure
  13. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  14. Create Pivot view in SQL from a SQL table
  15. How to send email using Oracle 10 g Forms
  16. Why doesn’t PL/SQL respect privileges granted by Roles?
  17. Can We use threading in PL/SQL?
  18. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  19. Oracle: how to INSERT if a row doesn’t exist
  20. What is the algorithm used by the ORA_HASH function?
  21. How to output result of SELECT statement which is executed using native dynamic SQL?
  22. passing in table name as plsql parameter
  23. Reading clob line by line with pl\sql
  24. Cursor For Loop with dynamic SQL-Statement
  25. How to use parameters in a ‘where value in…’ clause?
  26. Why cannot I create triggers on objects owned by SYS?
  27. No more data to read from socket
  28. automating rollback script oracle
  29. How do I get column datatype in Oracle with PL-SQL with low privileges?
  30. Escaping single quote in PLSQL

Leave a Comment