Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program. (display as -----------) Fill the blanks with the suitable PL/SQL...


Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program. (display as -----------)


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