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
2018-04-07, 828👍, 0💬
Popular Posts:
What Do You Need to Connect PHP to MySQL in MySQL? If you want to access MySQL database server in yo...
What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...