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;
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here