Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
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, 4873👍, 0💬
Popular Posts:
Can you have virtual functions in Java? Yes, all functions in Java are virtual by default. This is a...
What is PMP(project management plan)? The project management plan is a document that describes the p...
In which event are the controls fully loaded ? Page_load event guarantees that all controls are full...
Do You Know the Book "JUnit in Action"? You should know this book. It received some good reviews. Ti...
What will be printed as the result of the operation below: #define swap(a,b) a=a+b;b=a-b;a=a-b; void...