Trabajando con bucles anidados en pl/sql pero no mostrando la salida adecuada.
SET SERVEROUTPUT ON SIZE 4000; DECLARE call_id COURSE.CALL_ID%type; sec_num COURSE_SECTION.SEC_NUM%type; fname STUDENT.S_FIRST%TYPE ; lname STUDENT.S_LAST%TYPE; CURSOR c_info is SELECT CALL_ID , SEC_NUM FROM COURSE_SECTION ,COURSE,TERM WHERE COURSE_SECTION.COURSE_ID = COURSE.COURSE_ID AND TERM.TERM_ID = COURSE_SECTION.TERM_ID AND TERM.TERM_DESC = ‘Summer 2007’ ; CURSOR S_NAME IS SELECT DISTINCT S_FIRST, S_LAST FROM STUDENT,COURSE_SECTION,TERM,ENROLLMENT WHERE TERM.TERM_ID . . . Read more