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
Explicit Cursor → An 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 cursor … cursor. A 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 Attribute → Every 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
Cursor Variable Declaration → A 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
SQL (Implicit) Cursor Attribute → A 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
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
Restrictions on Cursor Variables → Currently, 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,
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
Cursor FOR LOOP → Topics: 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
Using Cursor Expressions → A 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
Passing Data with Cursor Variables → You 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
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
Passing Cursor Variables As Parameters → You 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
Avoiding Errors with Cursor Variables → If 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
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
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
cursor → The 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
cursor → The cursor variable describes the previously declared dynamic cursor. Examples EXEC SQL CLOSE C1 END-EXEC.
cursor → The 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