-- Question 2
DECLARE
    error_message   varchar2(512);
    V_COURSE_ID     COURSE.COURSE_ID%TYPE;
    V_COURSE_NAME   COURSE.COURSE_NAME%TYPE;
    V_C_SEC_ID      COURSE_SECTION.C_SEC_ID%TYPE;
    V_F_ID          COURSE_SECTION.F_ID%TYPE;
BEGIN
    SELECT COURSE.COURSE_ID AS "Code",
    COURSE_NAME AS "Name",
    C_SEC_ID AS "Sec",
    F_ID AS "Fac"
    INTO
    V_COURSE_ID,
    V_COURSE_NAME,
    V_C_SEC_ID,
    V_F_ID
    FROM COURSE_SECTION JOIN COURSE
    ON COURSE_SECTION.COURSE_ID = COURSE.COURSE_ID;
EXCEPTION
    WHEN NO_DATA_FOUND THEN
    DBMS_OUTPUT.PUT_LINE('There is no data!');
    WHEN others THEN
    error_message := SQLERRM;
    DBMS_OUTPUT.PUT_LINE('This program encountered the following error: ');
    DBMS_OUTPUT.PUT_LINE(error_message);
END;
/