You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for CURSOR


1 to 20 of 1345 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 13 of 52

Cursor Variables… To access the information, you can use an explicit cursor, which names the work area. Or, you can … use a cursor variable, which points to the work area. Whereas a cursor always refers to the same … query work area, a cursor variable can refer to different work areas. To create cursor variables,

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Datatypes and Host Variables

Cursor VariablesYou can use cursor variables in your Pro*C/C++ program for queries. A cursor variable is a handle … for a cursor that must be defined and opened on the Oracle (release 7.2 or later) server, using PL … /SQL. See the PL/SQL User's Guide and Reference for complete information about cursor variables. The … advantages

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 12 of 52

Cursor AttributesEvery explicit cursor and cursor variable has four attributes: %FOUND, %ISOPEN %NOTFOUND, and … %ROWCOUNT. When appended to the cursor or cursor variable, these attributes return useful information … about the execution of a data manipulation statement. For more information, see "Using Cursor

SQL*Module for Ada Programmer's Guide, 9i Release 2 (9.2.0.2)

Module Language

Cursor DeclarationsWhen a query can return multiple rows of data, you must declare a cursor for the statement. There … are two different kinds of cursor that you can use in Module Language. You can declare an ANSI … -standard cursor in your module file, and write module language procedures to OPEN the cursor, FETCH from … it, and

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

ANSI Dynamic SQL

OPEN CursorPurpose The OPEN statement associates input parameters with a cursor and then opens the cursor … file in which it is allocated. LOCAL is the default. dyn_cursor The cursor variable. desc_nam1 … , desc_nam2 The optional descriptor names. Usage notes If the prepared statement associated with the cursor

SQL*Module for Ada Programmer's Guide, 9i Release 2 (9.2.0.2)

Accessing Stored Procedures

Cursor VariablesYou can use cursor variables in your application. A cursor variable is a reference to a cursor that … complete information about cursor types. The advantages of cursor variables are Encapsulation: queries … are centralized, placed in the stored procedure that opens the cursor variable.

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Embedded PL/SQL

Cursor VariablesYou can use cursor variables in your Pro*COBOL programs to process multi-row queries using static … embedded SQL. A cursor variable identifies a cursor reference that is defined and opened on the … cursor variables. Like a cursor, a cursor variable points to the current row in the active

OLAP Developer's Guide to the OLAP API, 9i Release 2 (9.2.0.2)

Understanding Cursor Classes and Concepts, 3 of 6

Cursor Classthe following table. Interface Description Cursor An abstract superclass that encapsulates the notion … of a current position. ValueCursor A Cursor that has a value at the current position. A ValueCursor … has no child Cursor objects. CompoundCursor Cursor that has child Cursor objects, which are a child

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Using Procedures and Packages

Cursor VariablesA cursor is a static object; a cursor variable is a pointer to a cursor. Because cursor variables … are pointers, they can be passed and returned as parameters to procedures and functions. A cursor … variable can also refer to different cursors in its lifetime. Some additional advantages of cursor

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Host Arrays

Cursor Fetchescursor, then fetch from it in "batches." Batch fetches within a loop let you retrieve a large number of … emp_cursor CURSOR FOR SELECT empno, sal FROM emp; EXEC SQL OPEN emp_cursor; EXEC SQL WHENEVER NOT FOUND

SQL Reference, 9i Release 2 (9.2.0.2)

Expressions, 6 of 14

CURSOR ExpressionsA CURSOR expression returns a nested cursor. This form of expression is equivalent to the PL/SQL … REF CURSOR and can be passed as a REF CURSOR argument to a function. cursor_expression::= Text … description of cursor_expression A nested cursor is implicitly opened when the cursor expression

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 48 of 52

SQL CursorOracle implicitly opens a cursor to process each SQL statement not associated with an explicit … cursor. PL/SQL lets you refer to the most recent implicit cursor as the SQL cursor, which always has … execution of data manipulation statements. The SQL cursor has additional attributes, %BULK_ROWCOUNT

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Overview of PL/SQL

Cursor VariablesLike a cursor, a cursor variable points to the current row in the result set of a multi-row query … . But, unlike a cursor, a cursor variable can be opened for any type-compatible query. It is not tied … to a specific query. Cursor variables are true PL/SQL variables, to which you can assign new values

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

ANSI Dynamic SQL

OPEN CursorPurpose The OPEN statement associates input parameters with a cursor and then opens the cursor … . dyn_cursor The cursor variable. GLOBAL | LOCAL The optional scope clause defaults to LOCAL if not … If the prepared statement associated with the cursor contains colons or question marks, a USING

Objects for OLE, 9i Release 2 (9.2.0.2)

Example: Multiple Cursor Return

Example: Multiple Cursor ReturnMaster Index Feedback Example: Multiple Cursor Return This example uses the package GetEmpData … associated with cursor params.Remove("EMPCURSOR"); params.Remove("DEPTNO");   Copyright © 1998, 2002

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Interaction Between PL/SQL and Oracle

Using Cursor AttributesEvery explicit cursor and cursor variable has four attributes: %FOUND, %ISOPEN %NOTFOUND, and … %ROWCOUNT. When appended to the cursor or cursor variable, these attributes return useful information … about the execution of a data manipulation statement. You can use cursor attributes in procedural statements

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Datatypes and Host Variables

Open a Cursor VariableYou must open a cursor variable on the Oracle database server. You cannot use the embedded SQL OPEN … command to open a cursor variable. You can open a cursor variable either by calling a PL/SQL stored … procedure that opens the cursor (and defines it in the same statement). Or, you can open and define … a cursor

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Interaction Between PL/SQL and Oracle

Restrictions on Cursor VariablesCurrently, cursor variables are subject to the following restrictions: You cannot declare cursor … AS TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE; emp_cv EmpCurTyp; -- not allowed END emp_stuff … ; Remote subprograms on another server cannot accept the values of cursor variables. Therefore, you … cannot use

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Embedded SQL

Closing a CursorWhen finished fetching rows from the active set, you close the cursor to free the resources, such … as storage, acquired by opening the cursor. When a cursor is closed, parse locks are released. What … following example, you close the cursor named EMPCURSOR: EXEC SQL CLOSE EMPCURSOR END-EXEC. You cannot … fetch

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Oracle Dynamic SQL: Method 4

CLOSE the CursorCLOSE disables the cursor. In our example, CLOSE disables EMPCURSOR as follows: EXEC SQL CLOSE