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 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,
Cursor Variables → You 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
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 Declarations → When 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
OPEN Cursor → Purpose 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
Cursor Variables → You 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.
Cursor Variables → You 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
Cursor Class → 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 Cursor that has child Cursor objects, which are a child
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 Fetches → cursor, 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
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::= Text … description of cursor_expression A nested cursor is implicitly opened when the cursor expression
SQL Cursor → Oracle 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
Cursor Variables → Like 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
OPEN Cursor → Purpose 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
Example: Multiple Cursor Return → Master Index Feedback Example: Multiple Cursor Return This example uses the package GetEmpData … associated with cursor params.Remove("EMPCURSOR"); params.Remove("DEPTNO"); Copyright © 1998, 2002
Using 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. You can use cursor attributes in procedural statements
Open a Cursor Variable → You must open a cursor variable on the Oracle database server. You cannot use the embedded SQL OPEN … command to open a cursor variable. You can open a cursor variable either by calling a PL/SQL stored … procedure that opens the cursor (and defines it in the same statement). Or, you can open and define … a cursor
Restrictions on Cursor Variables → Currently, cursor variables are subject to the following restrictions: You cannot declare cursor … AS TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE; emp_cv EmpCurTyp; -- not allowed END emp_stuff … ; Remote subprograms on another server cannot accept the values of cursor variables. Therefore, you … cannot use
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