Question: please give the answer early thank you For the PL/SQL Fill in the blanks, you need to fill up the following line number: 10,12, 22,

please give the answer early thank you

 please give the answer early thank you For the PL/SQL Fill

For the PL/SQL Fill in the blanks, you need to fill up the following line number: 10,12, 22, 23 Evaluate the PL/SQL block. Fill in the empty lines with appropriate PL/SQL commands The PL/SQL block is based on the Student Database. Lists the courses taken by a certain student and Allows the user to enter the STUDENT NAME: 1. ACCEPT studname PROMPT Enter the student name: 2. 3. DECLARE 14. v_cid course.courseno%TYPE: 15. 5 v_sname student.studname%TYPE; v_cname course.coursename%TYPE; 16. 7. 18. CURSOR course_list IS 19. SELECT c.courseno, c.coursename , 110. 11. WHERE s.studno = r.studno 12. 13. AND studname = '&studname'; 14. 15. BEGIN 16. 17. OPEN course_list; 18. 19. DBMS_OUTPUT.PUT_LINE('List of courses for ' l'&studname'); 20. 21. LOOP 22. 23. 24. DBMS_OUTPUT.PUT_LINE(v_cid||' "|v_cname); 25. 26. END LOOP; 27. 28. CLOSE course_list; 129 END

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!