Databases

       To get the number of rows in all tables in Oracle database, use this query. SELECT table_name,num_rows FROM all_tables WHERE owner = 'SCHEMA';

To get the number of rows in all tables in MySQL database, use this query. SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'databaseName;