declare
v_course_id classes.course_id%type:=:course;
v_nr_c number(6);
begin
select count(class_id) into v_nr_c
from classes
where course_id=v_course_id;
dbms_output.put_line('The course: '||v_course_id||' has '||v_nr_c||' classes.');
end;