About us
Services
Products
Work
Contact
Feedback
In Focus
Flash XML slideshow
Database training
4.1.15. PL Cursors
DECLARE
name_attr EMPLOYEE.NAME%TYPE;
ssn_attr EMPLOYEE.SSN%TYPE;
/* cursor declaration */
CURSOR myEmployeeCursor IS
SELECT NAME,SSN FROM EMPLOYEE
WHERE DNO=1
FOR UPDATE;
emp_tuple myEmployeeCursor%ROWTYPE;
‹ 4.1.14. Impact
up
4.1.16. Cursors execution ›
s5 slideshow