set serveroutput on

declare 
    cursor c is select * from all_tables; 
    n number; 
begin 
    n := 0; 
    for row in c loop 
        n := n + 1; 
    end loop; 
    dbms_output.put_line('Total rows = ' || n); 
end;