December 2002
Intermediate to advanced
928 pages
85h 29m
English
To declare an explicit cursor as a cursor variable in the declaration section of a block or package (discussed later), you can use one of the following forms:
A cursor without parameters, such as:
CURSOR company_cur IS SELECT company_id FROM company;
A cursor that accepts arguments through a parameter list, described under the “Heading Section” header:
CURSOR company_cur (id_in IN NUMBER) IS
SELECT name FROM company
WHERE company_id = id_in;A cursor header that contains a RETURN clause in place of the SELECT statement:
CURSOR company_cur (id_in IN NUMBER)
RETURN company%ROWTYPEThe last example shows that the cursor can be declared separately from its implementation—for example, the header in a package specification and the implementation in the package body.