SET serveroutput ON;

DECLARE
    course_number Course.course_no%TYPE;
    course_name Course.course_name%TYPE;
    term_desc Term.term_desc%TYPE;
    faculty_first faculty.f_first%TYPE;
    faculty_last faculty.f_last%TYPE;
    DAY course_section.c_sec_day%TYPE;
    TIME course_section.c_sec_time%TYPE;
    bldg_code location.bldg_code%TYPE;
    room location.room%TYPE;
BEGIN
    SELECT c.course_no, c.course_name, t.term_desc, f.f_first, f.f_last, cs.c_sec_day, cs.c_sec_time, loc.bldg_code,
    loc.room
    INTO course_number, course_name, term_desc, faculty_first, faculty_last, DAY, TIME, bldg_code, room
    FROM course_section cs
    INNER JOIN course c ON cs.course_no = c.course_no
    INNER JOIN term t ON cs.term_id = t.term_id
    INNER JOIN faculty f ON cs.f_id = f.f_id
    INNER JOIN location loc ON cs.loc_id = loc.loc_id
    WHERE cs.c_sec_id = 1;

    DBMS_OUTPUT.put_line('Term: ' || term_desc);
    DBMS_OUTPUT.put_line('Course: ' || course_number || ' ' || course_name);
    DBMS_OUTPUT.put_line('Time: ' || DAY || ' ' || TO_CHAR(TIME, 'HH:MM AM'));
    DBMS_OUTPUT.put_line('Location: ' || bldg_code || ' ' || room);
    DBMS_OUTPUT.put_line('Instructor: ' || faculty_first || ' ' || faculty_last);
END;