CREATE OR REPLACE PROCEDURE INTRODUCTIE_CURSUS_SECTIONS AS
CURSOR c_ins IS
  SELECT * FROM SECTION s
  WHERE CAPACITY - (SELECT COUNT(*) FROM ENROLLMENT e
                    WHERE S.SECTION_ID = E.SECTION_ID) >= 10;

v_tab COURSE%ROWTYPE;

BEGIN
  FOR r_ins IN c_ins
  LOOP
    SELECT * INTO v_tab FROM COURSE c WHERE
      r_ins.course_no = c.course_no;
      IF v_tab.description LIKE '%Intro%' THEN
        DBMS_OUTPUT.PUT_LINE(v_tab.course_no || ' ' || v_tab.description || ' ' || r_ins.section_id);
      END IF;
  END LOOP;
END INTRODUCTIE_CURSUS_SECTIONS;