Weather Observation Station 4

  • + 0 comments
    set serveroutput on
    declare 
    v_no_1 number;
    v_no_2 number;
    BEGIN
    select count(city) into v_no_1 from station;
    select count(distinct city) into v_no_2 from station;
    dbms_output.put_line(v_no_1-v_no_2);
    end;
    

    /