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


Pro*C/C++ Programmer's Guide

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

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

Pro*C/C++ Programmer's Guide

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

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*COBOL® Programmer's Guide

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

SQL*Module for Ada Programmer's Guide

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.

User's Guide and Reference

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

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

User's Guide and Reference

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

Application Developer's Guide - Fundamentals

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

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

OLAP Developer's Guide to the OLAP API

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

SQL*Module for Ada Programmer's Guide

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

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

Objects for OLE

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

Pro*C/C++ Programmer's Guide

Host Arrays

Scrollable Cursor Fetches"Sample Program: Host Arrays Using Scrollable Cursor" for an example illustrating the use of host arrays with scrollable cursors.

User's Guide and Reference

Native Dynamic SQL

Closing the Cursor VariableThe CLOSE statement disables a cursor variable. After that, the associated result set is undefined … row is processed, you close cursor variable emp_cv: LOOP FETCH emp_cv INTO my_ename, my_sal; EXIT … WHEN emp_cv%NOTFOUND; -- process row END LOOP; CLOSE emp_cv; -- close cursor variable If you try to … close an already-closed or

User's Guide and Reference

Interaction Between PL/SQL and Oracle

Declaring Cursor VariablesOnce you define a REF CURSOR type, you can declare cursor variables of that type in any PL/SQL … block or subprogram. In the following example, you declare the cursor variable dept_cv: DECLARE TYPE … DeptCurTyp IS REF CURSOR RETURN dept%ROWTYPE; dept_cv DeptCurTyp; -- declare cursor variable Note: You

User's Guide and Reference

Interaction Between PL/SQL and Oracle

Restrictions on Cursor ExpressionsYou cannot use a cursor expression with an implicit cursor. Cursor expressions can appear only: In … the cursor expression itself. As arguments to table functions, in the FROM clause of a SELECT … statement. Cursor expressions can appear only in the outermost SELECT list of the query specification

Pro*COBOL® Programmer's Guide

Embedded PL/SQL

Closing a Cursor VariableUse the embedded SQL CLOSE statement to close a cursor variable. At this point its active set … can be executed on the client side or the server side. The following example closes the cursor … END-EXEC. * Declare the cursor variable. 01 CUR-VAR SQL-CURSOR.... EXEC SQL END DECLARE SECTION END … -EXEC. PROCEDURE