SELECT NUMBER OF rows for all tables oracle code example Example: SELECT NUMBER OF rows for all tables oracle SELECT table_name,num_rows FROM all_tables