QUESTION 2 Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program. DECLARE CURSOR cursor1 IS SELECT * FROM Students; line cursor1...


QUESTION 2







  1. Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program.




    DECLARE


    CURSOR cursor1 IS SELECT * FROM Students;


    line cursor1 %type;



    BEGIN


    OPEN cursor1;


    LOOP


    SELECT cursor1 inside line;


    DBMS_OUTPUT.PUT_LINE('first name=  '|| line.fname || 'last name= '||line.lname);


    EXIT WHEN Cursor %FOUND;


    END LOOP;


    CLOSE cursor1;



    END;








Jun 07, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here