get number of rows in table sql oracle code example

Example: SELECT NUMBER OF rows for all tables oracle

SELECT table_name,num_rows FROM all_tables