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


Database PL/SQL Language Reference, 11g Release 1 (11.1)

Explicit Cursor

Explicit CursorAn explicit cursor names the unnamed work area in which the database stores processing information … cursor previously declared within the current scope. datatype A type specifier. For the syntax of … data types. Note: If you supply an actual parameter for parameter_name when you open the cursorcursor. A cursor

Database SQL Language Reference, 11g Release 1 (11.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. Description of the illustration … cursor_expression.gif A nested cursor is implicitly opened when the cursor expression

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Cursor Attribute

Cursor AttributeEvery explicit cursor and cursor variable has four attributes, each of which returns useful … cursor previously declared within the current scope. cursor_variable_name A PL/SQL cursor variable … (or parameter) previously declared within the current scope. %FOUND Attribute A cursor attribute that

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Cursor Variable Declaration

Cursor Variable DeclarationA cursor variable points to the unnamed work area in which the database stores processing … information, and process the rows of the query individually. A cursor variable is like a C or Pascal … pointer, which holds the address of an item instead of the item itself. To create a cursor variable … , define a REF CURSOR

Database PL/SQL Language Reference, 11g Release 1 (11.1)

SQL (Implicit) Cursor Attribute

SQL (Implicit) Cursor AttributeA SQL (implicit) cursor is opened by the database to process each SQL statement that is not … associated with an explicit cursor. Every SQL (implicit) cursor has six attributes, each of which returns … Always returns FALSE, because the database closes the SQL cursor automatically after executing its … , or returned

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Static 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

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Static SQL

Restrictions on Cursor VariablesCurrently, cursor variables are subject to the following restrictions: You cannot declare cursor … variables in a package specification, as illustrated in Example 6-34. If you bind a host cursor … it there on the same server call. You cannot use comparison operators to test cursor variables for … equality, inequality,

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Static SQL

Why Use Cursor Variables?You use cursor variables to pass query result sets between PL/SQL stored subprograms and various … work area. A query work area remains accessible as long as any cursor variable points to it, as you … pass the value of a cursor variable from one scope to another. For example, if you pass a host … cursor variable

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Static SQL

Cursor FOR LOOPTopics: SQL Cursor FOR LOOP Explicit Cursor FOR LOOP SQL Cursor FOR LOOP With PL/SQL, it is very … cursor is closed automatically. The cursor is closed even if you use an EXIT or GOTO statement to leave … . Explicit Cursor FOR LOOP If you must reference the same query from different

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Static SQL

Using Cursor ExpressionsA cursor expression returns a nested cursor. Each row in the result set can contain values, as … within those rows. PL/SQL supports queries with cursor expressions as part of cursor declarations, REF … CURSOR declarations and REF CURSOR variables. (You can also use cursor

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Tuning PL/SQL Applications for Performance

Passing Data with Cursor VariablesYou can pass a set of rows to a PL/SQL function in a REF CURSOR parameter. For example, this … function is declared to accept an argument of the predefined weakly typed REF CURSOR type SYS_REFCURSOR … directly: SELECT * FROM TABLE(f(CURSOR(SELECT empid FROM tab))); In the preceding example, the CURSOR … keyword

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Static SQL

Using Cursor Variables (REF CURSORs)Like a cursor, a cursor variable points to the current row in the result set of a multiple-row … query. A cursor variable is more flexible because it is not tied to a specific query. You can open a … cursor variable for any query that returns the right set of columns. You pass a cursor variable as a

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Static SQL

Passing Cursor Variables As ParametersYou can declare cursor variables as the formal parameters of subprograms. Example 6-27 defines a … REF CURSOR type, then declares a cursor variable of that type as a formal parameter. Example 6-27 … Passing a REF CURSOR as a Parameter DECLARE TYPE empcurtyp IS REF CURSOR RETURN employees%ROWTYPE; emp

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Static SQL

Avoiding Errors with Cursor VariablesIf both cursor variables involved in an assignment are strongly typed, they must have exactly the … same data type (not just the same return type). If one or both cursor variables are weakly typed … , they can have different data types. If you try to fetch from, close, or refer to cursor attributes of a … cursor

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Static SQL

What Are Cursor Variables (REF CURSORs)?Cursor variables are like pointers to result sets. You use them when you want to perform a query in … different language). A cursor variable has data type REF CURSOR, and you might see them referred to … informally as REF CURSOR s. Unlike an explicit cursor, which always refers to the same query work

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Static SQL

Looping Through Multiple Rows (Cursor FOR Loop)Perhaps the most common case of a query is one where you issue the SELECT statement, then immediately loop once through the rows of the result set. PL/SQL lets you use a simple FOR loop for this kind of query. The iterator variable for the FOR loop does need not be declared in advance. It is a %ROWTYPE record whose field names match the column names from the query, and that exists only during the

OLAP DML Reference, 11g Release 1 (11.1)

SQL

cursorThe name of a cursor previously declared in the same program. You cannot use ampersand substitution … . Examples Example 10-142 Opening a Cursor Using SQL OPEN The following program fragment declares … and opens a cursor named geolabels. SQL DECLARE geolabels CURSOR FOR - SELECT Store_ID, Store_Name

Pro*COBOL Programmer's Guide, 11g Release 1 (11.1)

ANSI Dynamic SQL

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

OLAP DML Reference, 11g Release 1 (11.1)

SQL

cursorThe name of a cursor previously opened with a SQL OPEN statement. 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

OLAP DML Reference, 11g Release 1 (11.1)

SQL

cursorThe name of a declared cursor. var-num-of-rows The name of a variable that specifies the number of … CURSOR command that declared cursor. A target can be a variable, a qualified data reference, a relation