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