110011
DECLARE
sid enrollment.sid%TYPE;
cid enrollment.cid%TYPE;
edate enrollment.edate%TYPE;
cname course.cname%TYPE;
duration course.duration%TYPE;
BEGIN
FOR rec IN (SELECT e.sid, e.cid, e.edate, c.cname, c.duration
FROM enrollment e
JOIN course c ON e.cid = c.cid) LOOP
sid := rec.sid;
cid := rec.cid;
edate := rec.edate;
cname := rec.cname;
duration := rec.duration;
DBMS_OUTPUT.PUT_LINE(
'Student ID: ' || sid ||
', Course ID: ' || cid ||
', End Date: ' || edate ||
', Course Name: ' || cname ||
', Duration: ' || duration
);
END LOOP;
END;