Oracle row count for all tables in schema

Oracle row count for all tables in schema


select owner, table_name, num_rows, last_analyzed from all_tables;

Output:

Leave a Reply

Your email address will not be published. Required fields are marked *