How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
cursor → The 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
CURSOR → A 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
cursor → The 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
cursor → The 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
cursor → The 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
cursor → The 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
SQL Cursor → Oracle 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
CURSOR Expressions → A 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
Cursor Attributes → Every 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
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
Cursor Variables → This 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
Cursor Variables → A 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
Cursor Variables → Starting 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
Declaring REF CURSOR Types and Cursor Variables → To 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
5.4.17 CLOSE the Cursor → CLOSE disables the cursor. In our example, CLOSE disables EMP_CURSORas follows: EXEC SQL CLOSE EMP_CURSOR;
Allocating a Cursor Variable → cursor 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
Opening a Cursor → EXEC 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.
5.4.4 Closing a Cursor → When 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
9.2 Cursor Classes → the 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