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 → A 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
CURSOR Expressions → A 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
Cursor Variable Declaration → A 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
Implicit Cursor Attribute → An 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
Named Cursor Attribute → Every 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
Cursor FOR LOOP Statement → The 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
Creating Cursor Variables → 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. Note: Informally, a cursor variable … is sometimes called a REF CURSOR ). The basic syntax of a REF CURSOR type definition is: TYPE
Cursor Variable Attributes → A 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
Explicit Cursor Declaration and Definition → An 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
Fetching Data with Cursor Variables → After 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.
Cursor Variables as Subprogram Parameters → You 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
Cursor Variables as Host Variables → You 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
Assigning Values to Cursor Variables → You 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
Opening and Closing Cursor Variables → After 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
Variables in Cursor Variable Queries → The 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
Passing CURSOR Expressions to Pipelined Table Functions → As 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
Query Result Set Processing With Cursor FOR LOOP Statements → The cursor FOR LOOP statement lets you run a SELECT statement and then immediately loop through the … rows of the result set. This statement can use either an implicit or explicit cursor. If you use … the SELECT statement only in the cursor FOR LOOP statement, then specify the SELECT statement inside … the cursor
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. Description of the illustration … ''cursor_expression.gif'' A nested cursor is implicitly opened when the cursor expression
cursor → A handle or name for a private SQL area in the PGA. Because cursors are closely associated with private SQL areas, the terms are sometimes used interchangeably.
cursor → The 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