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 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
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 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*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 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.
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 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 → 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
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
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
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 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
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
Scrollable Cursor Fetches → "Sample Program: Host Arrays Using Scrollable Cursor" for an example illustrating the use of host arrays with scrollable cursors.
Closing the Cursor Variable → The CLOSE statement disables a cursor variable. After that, the associated result set is undefined … row is processed, you close cursor variable emp_cv: LOOP FETCH emp_cv INTO my_ename, my_sal; EXIT … WHEN emp_cv%NOTFOUND; -- process row END LOOP; CLOSE emp_cv; -- close cursor variable If you try to … close an already-closed or
Declaring Cursor Variables → Once you define a REF CURSOR type, you can declare cursor variables of that type in any PL/SQL … block or subprogram. In the following example, you declare the cursor variable dept_cv: DECLARE TYPE … DeptCurTyp IS REF CURSOR RETURN dept%ROWTYPE; dept_cv DeptCurTyp; -- declare cursor variable Note: You
Restrictions on Cursor Expressions → You cannot use a cursor expression with an implicit cursor. Cursor expressions can appear only: In … the cursor expression itself. As arguments to table functions, in the FROM clause of a SELECT … statement. Cursor expressions can appear only in the outermost SELECT list of the query specification
Closing a Cursor Variable → Use the embedded SQL CLOSE statement to close a cursor variable. At this point its active set … can be executed on the client side or the server side. The following example closes the cursor … END-EXEC. * Declare the cursor variable. 01 CUR-VAR SQL-CURSOR.... EXEC SQL END DECLARE SECTION END … -EXEC. PROCEDURE