Need to Create an Anonymous block that Inserts rows of data from the student table into a temporary table and uses a loop with a counter to know when to exit. Set the counter equal to the Count of the rows in the student table so it will know when to end processing. (You will need to create the Temporary Table first. Use a loop to take each row from the student table and place it in the Temporary Table).

CREATE TABLE Student1 ( Stu_ID INT, Lname VARCHAR2(25), Fname VARCHAR2(25), Mi VARCHAR2(2), Sex VARCHAR2(2), Major VARCHAR2(10), Home_State VARCHAR2(5), CONSTRAINT student_pk PRIMARY KEY(Stu_ID) );

INSERT INTO Student1 (Stu_ID, Lname, Fname, Mi, Sex, Major, Home_State) VALUES (10001, 'Smith', 'Sam', 'M', 'M', 'Math', 'Tx'); INSERT INTO Student1 (Stu_ID, Lname, Fname, Mi, Sex, Major, Home_State) VALUES (10002, 'Jones', 'Peter', 'A', 'M', 'English', 'TX'); INSERT INTO Student1 (Stu_ID, Lname, Fname, Mi, Sex, Major, Home_State) VALUES (10003, 'Peters', 'Anne', 'A', 'F', 'English', 'ME'); INSERT INTO Student1 (Stu_ID, Lname, Fname, Mi, Sex, Major, Home_State) VALUES (10004, 'Johnson', 'John', 'J', 'M', 'CompSci', 'Ca'); INSERT INTO Student1 (Stu_ID, Lname, Fname, Mi, Sex, Major, Home_State) VALUES (10005, 'Penders', 'Alton', 'P', 'F', 'Math', 'GA'); INSERT INTO Student1 (Stu_ID, Lname, Fname, Mi, Sex, Major, Home_State) VALUES (10006, 'Allen', 'Diane', 'J', 'F', 'Geography', 'Minn'); INSERT INTO Student1 (Stu_ID, Lname, Fname, Mi, Sex, Major, Home_State) VALUES (10007, 'Gill', 'Jennifer', NULL, 'F', 'CompSci', 'Tx'); INSERT INTO Student1 (Stu_ID, Lname, Fname, Mi, Sex, Major, Home_State) VALUES (10008, 'Johns', 'Roberta', NULL, 'F', 'CompSci', 'Tx'); INSERT INTO Student1 (Stu_ID, Lname, Fname, Mi, Sex, Major, Home_State) VALUES (10009, 'Wier', 'Paul', NULL, 'M', 'Math', 'Ala'); INSERT INTO Student1 (Stu_ID, Lname, Fname, Mi, Sex, Major, Home_State) VALUES (10010, 'Evans', 'Richard', NULL, 'M', 'English', 'Tx');

CREATE TABLE Course ( Course_ID VARCHAR2(25), Section# VARCHAR2(5), C_Name VARCHAR2(25), C_Description VARCHAR2(35), CONSTRAINT course_pk PRIMARY KEY(Course_ID) );

INSERT INTO Course (Course_ID, Section#, C_Name, C_Description) VALUES ('COSC1300', 001, 'Intro to Comp.', 'First Computer Course'); INSERT INTO Course (Course_ID, Section#, C_Name, C_Description) VALUES ('ITSE2309', 001, 'Intro to DB', 'First Database Course'); INSERT INTO Course (Course_ID, Section#, C_Name, C_Description) VALUES ('GEOG1791', 002, 'World Geography', 'Second Geography Course'); INSERT INTO Course (Course_ID, Section#, C_Name, C_Description) VALUES ('COSC1315', 001, 'Intro to Prog.', 'Second Computer Course'); INSERT INTO Course (Course_ID, Section#, C_Name, C_Description) VALUES ('ITSE1345', 001, 'Intro to DB Prog.', 'Second Database Course'); INSERT INTO Course (Course_ID, Section#, C_Name, C_Description) VALUES ('ENGL2617', 002, 'English Literature', 'Second English Course'); INSERT INTO Course (Course_ID, Section#, C_Name, C_Description) VALUES ('MATH1101', 001, 'Calculus 1', 'Second Math Course'); INSERT INTO Course (Course_ID, Section#, C_Name, C_Description) VALUES ('ENGL1001', 001, 'American Literature', 'First English Course'); INSERT INTO Course (Course_ID, Section#, C_Name, C_Description) VALUES ('MATH1011', 001, 'Trig. and Algebra', 'First Math Course'); INSERT INTO Course (Course_ID, Section#, C_Name, C_Description) VALUES ('GEOG1010', 001, 'Texas Geography', 'First Geography Course');

CREATE TABLE Student_Course ( Stu_ID INT, Course_ID VARCHAR2(25), Section# VARCHAR2(5), CONSTRAINT student_fk FOREIGN KEY(Stu_ID) REFERENCES Student1(Stu_ID), CONSTRAINT course_fk FOREIGN KEY(Course_ID) REFERENCES Course(Course_ID) );

INSERT INTO Student_Course (Stu_ID, Course_ID, Section#) VALUES (10001, 'MATH1101', 001); INSERT INTO Student_Course (Stu_ID, Course_ID, Section#) VALUES (10002, 'ENGL2617', 002); INSERT INTO Student_Course (Stu_ID, Course_ID, Section#) VALUES (10003, 'ENGL1001', 001); INSERT INTO Student_Course (Stu_ID, Course_ID, Section#) VALUES (10003, 'ENGL2617', 002); INSERT INTO Student_Course (Stu_ID, Course_ID, Section#) VALUES (10003, 'GEOG1010', 001); INSERT INTO Student_Course (Stu_ID, Course_ID, Section#) VALUES (10004, 'COSC1315', 001); INSERT INTO Student_Course (Stu_ID, Course_ID, Section#) VALUES (10005, 'MATH1101', 001); INSERT INTO Student_Course (Stu_ID, Course_ID, Section#) VALUES (10006, 'GEOG1010', 001); INSERT INTO Student_Course (Stu_ID, Course_ID, Section#) VALUES (10006, 'GEOG1791', 002); INSERT INTO Student_Course (Stu_ID, Course_ID, Section#) VALUES (10007, 'COSC1315', 001); INSERT INTO Student_Course (Stu_ID, Course_ID, Section#) VALUES (10007, 'ITSE2309', 001); INSERT INTO Student_Course (Stu_ID, Course_ID, Section#) VALUES (10008, 'COSC1315', 001); INSERT INTO Student_Course (Stu_ID, Course_ID, Section#) VALUES (10009, 'ITSE2309', 001); INSERT INTO Student_Course (Stu_ID, Course_ID, Section#) VALUES (10010, 'ENGL2617', 002);