Collections:
Use FETCH Statement in a Loop in Oracle
How To Use FETCH Statement in a Loop in Oracle?
✍: FYIcenter.com
If you have a cursor opened ready to use, you can also use the FETCH statement in a loop to retrieve data from the cursor more efficiently. But you need to remember to use an EXIT statement break the loop when the cursor pointer reaches the end. The script below gives you a good example:
CREATE OR REPLACE PROCEDURE FYI_CENTER AS CURSOR emp_cur IS SELECT * FROM employees WHERE manager_id = 101; emp_rec employees%ROWTYPE; BEGIN OPEN emp_cur; LOOP FETCH emp_cur INTO emp_rec; EXIT WHEN emp_cur%NOTFOUND; DBMS_OUTPUT.PUT_LINE('Name = ' || emp_rec.first_name || ' ' || emp_rec.last_name); END LOOP; CLOSE emp_cur; END; / Name = Nancy Greenberg Name = Jennifer Whalen Name = Susan Mavris Name = Hermann Baer Name = Shelley Higgins
⇒ Use an Explicit Cursor without OPEN Statements in Oracle
⇐ Retrieve Data from a Cursor to a RECORD in Oracle
2018-04-07, 1505🔥, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...