Skip Headers
Oracle® OLAP DML Reference
11g Release 2 (11.2)

E17122-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

SQLFETCH

The SQLFETCH function retrieves one or more rows of a column in a relational text.

Return value

TEXT

Syntax

SQLFETCH (cursorname [COLUMN column-number} {STOPAFTER number-of-rows])

Parameters

cursorname

A TEXT expression that is the name of the SQL cursor. The cursor must be opened and closed by the caller.

column-number

An INTEGER value that is the number of the column. (Default is 1.)

number-of-rows

The number of rows to read. (Default is all remaining rows).