Rewrite the given cursor using for loop: DECLARE emp rec employees°rowtype; CURSOR emps IS SELECT * FROM employees; BEGIN OPEN emps; LOOP FETCH emps INTO emp rec; EXT WHEN emps°onotfound; dbms_ output.put _line(emp _rec.first name|l' 'I|emp rec.salary); END LOOP: CLOSE emps; END;

Programming Logic & Design Comprehensive
9th Edition
ISBN:9781337669405
Author:FARRELL
Publisher:FARRELL
Chapter3: Understanding Structure
Section: Chapter Questions
Problem 17RQ
icon
Related questions
Question
Q1) Rewrite the given cursor using for loop: DECLARE emp rec employees°rowtype; CURSOR emps IS SELECT * FROM employees; BEGIN OPEN emps; LOOP FETCH emps INTO emp rec; EXT WHEN emps°onotfound; dbms_ output.put _line(emp _rec.first name|l' 'I|emp rec.salary); END LOOP: CLOSE emps; END;
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Lists
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage