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 1373 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


DML Reference, 10g Release 1 (10.1)

SQL

cursorThe name of a declared and opened cursor. LOOP Specifies that Oracle OLAP should implicitly loop … cursor, or an error occurs, or loopcount is satisfied. In most cases, you should use the LOOP clause … to improve the performance of SQL FETCH. When you do not specify a LOOP clause and the cursor

Application Developer's Guide - Object-Relational Features, 10g Release 1 (10.1)

2 Basic Components of Oracle Objects

CURSORA 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. See Also: Oracle Database SQL Reference

DML Reference, 10g Release 1 (10.1)

SQL

cursorThe name of a cursor previously opened with a SQL OPEN command. Notes Related OLAP DML Commands You … Objects". Redefining the Result Set You can change the result set associated with a cursor by closing … the cursor, setting the value of an input host variable, and issuing a new SQL OPEN command. You do not have to free the cursor

DML Reference, 10g Release 1 (10.1)

SQL

cursorThe name of a cursor previously declared in the same program. You cannot use ampersand substitution … Relational Data into Analytic Workspace Objects". Examples Opening a Cursor The following program fragment … declares and opens a cursor named geolabels. SQL DECLARE geolabels CURSOR FOR - SELECT Store_ID

DML Reference, 10g Release 1 (10.1)

SQL

cursorThe name of a declared cursor. targets Identifies the analytic workspace objects in which you want … -statement argument of the SQL DECLARE CURSOR command that declared cursor. A target can be a variable

DML Reference, 10g Release 1 (10.1)

SQL

cursorThe name of the cursor you are defining. See "Cursor Names". select-statement A SQL SELECT … statement that identifies the data you want to associate with the cursor. For the syntax of an SQL SELECT … write data to the table. This clause is required when the cursor will be used in an UPDATE … statement with a

User's Guide and Reference, 10g Release 1 (10.1)

SQL Cursor

SQL CursorOracle implicitly opens a cursor to process each SQL statement not associated with an explicit … cursor. In PL/SQL, you can 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

SQL Reference, 10g Release 1 (10.1)

CURSOR Expressions

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::= Description … of the illustration cursor_expression.gif A nested cursor is implicitly opened when the cursor

User's Guide and Reference, 10g Release 1 (10.1)

Cursor Attributes

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, 10g Release 1 (10.1)

Cursor Variables

Cursor Variables… You can access this area through an explicit cursor, which names the work area, or through a cursor … variable, which points to the work area. To create cursor variables, you define a REF CURSOR type … , then declare cursor variables of that type. Cursor variables are like

Release 1.8, 10g Release 1 (10.1)

Using Embedded SQL

Cursor VariablesThis section gives a brief overview of cursor variables. For more information, see your host … *COBOL and Pro*FORTRAN Precompilers, you can declare cursor variables. Like a cursor, a cursor … variable points to the current row in the active set of a multi-row query. Cursors differ from cursor

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

7 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*FORTRAN® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

Writing a Pro*FORTRAN Program

Cursor VariablesStarting with Release 1.7 of the Pro*FORTRAN Precompiler, you can use cursor variables in your Pro … *FORTRAN programs to process multi-row queries using static embedded SQL. A cursor variable … identifies a cursor reference that is defined and opened on the Oracle7 Server, Release 7.2 or later, using … PL/SQL. See the PL/SQL

User's Guide and Reference, 10g Release 1 (10.1)

6 Performing SQL Operations from PL/SQL

Declaring REF CURSOR Types and Cursor VariablesTo create cursor variables, you define a REF CURSOR type, then declare cursor variables of that … type. You can define REF CURSOR types in any PL/SQL block, subprogram, or package. In the following … example, you declare a REF CURSOR type that represents a result set from the DEPARTMENTS table: DECLARE

Pro*PL/1® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

5 Implementing Dynamic SQL Method 4

5.4.17 CLOSE the CursorCLOSE disables the cursor. In our example, CLOSE disables EMP_CURSORas follows: EXEC SQL CLOSE EMP_CURSOR;

Pro*FORTRAN® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

Writing a Pro*FORTRAN Program

Allocating a Cursor Variablecursor variable is just like any other Pro*FORTRAN host variable. Allocating a Cursor Variable Before … you can OPEN or FETCH a cursor variable, you must allocate it using the Pro*FORTRAN ALLOCATE command … . For example, to allocate the cursor variable CURVAR that was declared in the previous section, write the following

Release 1.8, 10g Release 1 (10.1)

Using Embedded SQL

Opening a CursorEXEC SQL DECLARE emp_cursor CURSOR FOR SELECT ENAME, EMPNO, SAL FROM EMP WHERE DEPTNO … =:dept_number; The cursor name is an identifier used by the precompiler, not a host or program variable, and … should not be defined in the Declare Section. Therefore, cursor names cannot be passed from one … precompilation unit to another.

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

5 Embedded SQL

5.4.4 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

Developer's Guide to the OLAP API, 10g Release 1 (10.1)

9 Understanding Cursor Classes and Concepts

9.2 Cursor Classesthe 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 A Cursor that has child Cursor objects, which are a

Oracle® SQL*Module for Ada Programmer's Guide, 10g Release 1 (10.1)

3 Accessing Stored Procedures

3.7.1 Cursor Variable ParametersYou define a cursor variable parameter in your module using the type SQL_CURSOR. For example