Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Loop through a Cursor Variable
How To Loop through a Cursor Variable? - Oracle DBA FAQ - Working with Cursors in PL/SQL
✍: FYIcenter.com
Once a cursor variable is opened with a query statement, it will have the same attributes as a normal cursor and it can be used in the same way a normal cursor too. The following sample script shows you how to loop through a cursor variable:
CREATE OR REPLACE PROCEDURE FYI_CENTER AS TYPE emp_ref IS REF CURSOR RETURN employees%ROWTYPE; emp_cur emp_ref; emp_rec employees%ROWTYPE; BEGIN OPEN emp_cur FOR SELECT * FROM employees WHERE manager_id = 101; 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
2007-04-28, 4744👍, 0💬
Popular Posts:
How to set a HTML document's background color? document.bgcolor property can be set to any appropria...
What's difference between HashTable and ArrayList ? You can access array using INDEX value of array,...
How can we implement singleton pattern in .NET? Singleton pattern mainly focuses on having one and o...
Can we get a strongly typed resource class rather than using resource manager? In the previous quest...
interview.FYIcenter.com offers a collections of interview questions and answers for software and Web...