Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_SQL , 10 of 20
This function fetches a row from a given cursor. You can call FETCH_ROWS
repeatedly as long as there are rows remaining to be fetched. These rows are retrieved into a buffer, and must be read by calling COLUMN_VALUE
, for each column, after each call to FETCH_ROWS
.
The FETCH_ROWS
function accepts the ID number of the cursor to fetch, and returns the number of rows actually fetched.
DBMS_SQL.FETCH_ROWS ( c IN INTEGER) RETURN INTEGER;
Parameter | Description |
---|---|
c |
ID number. |
pragma restrict_references(fetch_rows,WNDS);
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|