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;
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;
Chapter2: Basic Sql Select Statements
Section: Chapter Questions
Problem 10RQ: What is a NULL value?
Related questions
Question
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;
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you