Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Named iterators

To declare a named iterator class, use the following syntax:

#sql [modifiers] iterator class_name 
        [implements interface_class [, interface_class . . .]] 
        [with constant_name = value [,constant_name = value . . .]]
        (java_type 
                     column_name [, java_type 
                     column_name ...]);

where:

modifiers

Optional Java class modifier: public, private, protected, static.

class_name

Name for the iterator class.

interface_class

The interface(s) implemented by the iterator class. If the iterator implements the sqlj.runtime.Scrollable class (available with Oracle 8.1.7 and later), the iterator will support the following navigation functions:

  • previous( )

  • first( )

  • last( )

  • absolute(row_number)

  • relative(relative_number): number of rows relative to current row

  • afterLast( )

  • beforeFirst( )

and these other functions:

  • setFetchDirection(direction), where direction can be a constant in sqlj.runtime.ResultSetIterator of FETCH_FORWARD, FETCH_REVERSE, or FETCH_UNKNOWN as a hint

  • getFetchDirection( )

  • isFirst( )

  • isLast( )

  • isBeforeFirst( )

  • isAfterLast( )

constant_name

Name of a constant that can be accessed in the iterator.

java_type

Java datatype of an iterator column.

column_name

Name of the column in the iterator. If this name is different from the column name, you should use AS to identify the iterator column.

Once you have declared a named iterator, you can select into it with this syntax:

#sql iterator_name = {sql_statement};

When the named iterator has been populated, you can move through the rows in the iterator by using ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page