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


Database SQL Language Reference, 11g Release 2 (11.2)

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

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Cursor VariablesA cursor variable is like an explicit cursor, except that: It is not limited to one query. You can … open a cursor variable for a query, process the result set, and then use the cursor variable for … parameter. You can use cursor variables to pass query result sets between subprograms. It can be a

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

CURSOR ExpressionsA CURSOR expression returns a nested cursor. It has this syntax: CURSOR ( subquery ) You can use a … CURSOR expression in a SELECT statement that is not a subquery (as in Example 6-34 ) or pass it to a … function that accepts a cursor variable parameter (see \"Passing CURSOR Expressions

Database PL/SQL Language Reference, 11g Release 2 (11.2)

Cursor Variable Declaration

Cursor Variable DeclarationA cursor variable is like an explicit cursor that is not limited to one query. To create a cursor … variable, either declare a variable of the predefined type SYS_REFCURSOR or define a REF CURSOR type … and then declare a variable of that type. Restrictions on Cursor Variables You cannot declare a

Database PL/SQL Language Reference, 11g Release 2 (11.2)

Implicit Cursor Attribute

Implicit Cursor AttributeAn implicit cursor has attributes that return information about the most recently run SELECT or DML … statement that is not associated with a named cursor. Note: You can use cursor attributes only in … Completes\". Examples Example 6-3, \"SQL%FOUND Implicit Cursor Attribute\" Example 6-4, \"SQL%ROWCOUNT … Implicit

Database PL/SQL Language Reference, 11g Release 2 (11.2)

Named Cursor Attribute

Named Cursor AttributeEvery named cursor (explicit cursor or cursor variable) has four attributes, each of which returns … information about the execution of a DML statement. Note: You can use cursor attributes only in … named_cursor %ISOPEN has the value TRUE if the cursor is open, and FALSE if it is not open. %FOUND

Database PL/SQL Language Reference, 11g Release 2 (11.2)

Cursor FOR LOOP Statement

Cursor FOR LOOP StatementThe cursor FOR LOOP statement implicitly declares its loop index as a record variable of the row … type that a specified cursor returns, and then opens a cursor. With each iteration, the cursor FOR … , the cursor FOR LOOP statement closes the cursor. The cursor also

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Creating Cursor VariablesTo create a cursor variable, either declare a variable of the predefined type SYS_REFCURSOR or … define a REF CURSOR type and then declare a variable of that type. Note: Informally, a cursor variable … is sometimes called a REF CURSOR ). The basic syntax of a REF CURSOR type definition is: TYPE

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Cursor Variable AttributesA cursor variable has the same attributes as an explicit cursor (see \"Explicit Cursor Attributes … \" ). The syntax for the value of a cursor variable attribute is cursor_variable_name immediately … followed by attribute (for example, cv%ISOPEN ). If a cursor variable is not open, referencing any

Database PL/SQL Language Reference, 11g Release 2 (11.2)

Explicit Cursor Declaration and Definition

Explicit Cursor Declaration and DefinitionAn explicit cursor is a named pointer to a private SQL area that stores information for processing … an explicit cursor to retrieve the rows of a result set one at a time. Before using an explicit … cursor, you must declare and define it. You can either declare it first (with cursor_declaration ) and … and define it at the same

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Fetching Data with Cursor VariablesAfter opening a cursor variable, you can fetch the rows of the query result set with the FETCH … cursor variable must be compatible with the into_clause of the FETCH statement. If the cursor … variable is strong, PL/SQL catches incompatibility at compile time. If the cursor variable is weak, PL/SQL … first fetch.

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Cursor Variables as Subprogram ParametersYou can use a cursor variable as a subprogram parameter, which makes it useful for passing query … results between subprograms. For example: You can open a cursor variable in one subprogram and process … it in a different subprogram. In a multilanguage application, a PL/SQL subprogram can use a cursor … and invoked subprograms

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Cursor Variables as Host VariablesYou can use a cursor variable as a host variable, which makes it useful for passing query results … between PL/SQL stored subprograms and their clients. When a cursor variable is a host variable, PL … set. To use a cursor variable as a host variable, declare the cursor variable in the host … environment and then

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Assigning Values to Cursor VariablesYou can assign to a PL/SQL cursor variable the value of another PL/SQL cursor variable or host … cursor variable. The syntax is: target_cursor_variable:= source_cursor_variable; If … source_cursor_variable is open, then after the assignment, target_cursor_variable is also open. The two cursor

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Opening and Closing Cursor VariablesAfter declaring a cursor variable, you can open it with the OPEN FOR statement, which does the … following: Associates the cursor variable with a query (typically, the query returns multiple rows) The … . For details, see \"Variables in Cursor Variable Queries\". If the query has a FOR UPDATE clause … \". Positions the cursor

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Variables in Cursor Variable QueriesThe query associated with a cursor variable can reference any variable in its scope. When you open … a cursor variable with the OPEN FOR statement, PL/SQL evaluates any variables in the query and uses … change the result set. Example 6-28 opens a cursor variable for a query that references the variable … incremented after every

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Optimization and Tuning

Passing CURSOR Expressions to Pipelined Table FunctionsAs Example 12-31 shows, the actual parameter for the cursor variable parameter of a pipelined table … function can be either a cursor variable or a CURSOR expression, and the latter is more efficient … . Note: When a SQL SELECT statement passes a CURSOR expression to a function, the referenced cursor

OLAP DML Reference, 11g Release 2 (11.2)

SQL

cursorThe name of a cursor previously opened with a SQL OPEN statement. Usage Notes Redefining the Result … Set You can change the result set associated with a cursor by closing the cursor, setting the value … of an OLAP DML input expression, and issuing a new SQL OPEN statement. You do not have to free the cursor and redeclare

Pro*COBOL Programmer's Guide, 11g Release 2 (11.2)

ANSI Dynamic SQL

cursorThe cursor variable describes the previously declared dynamic cursor. Examples EXEC SQL CLOSE C1 END-EXEC.

OLAP DML Reference, 11g Release 2 (11.2)

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, use the LOOP clause to improve the … performance of SQL FETCH. When you do not specify a LOOP clause and the cursor contains multiple