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
Overview of Table Functions → A table function is a user-defined PL/SQL function that returns a collection of rows (an … associative array, nested table or varray). You can select from this collection as if it were a database table … by invoking the table function inside the TABLE clause in a SELECT statement. For example: SELECT
Mutating-Table Restriction → Note: This topic applies only to row-level simple DML triggers. A mutating table is a table that is … being modified by an INSTEAD OF trigger is not considered to be mutating.) The mutating-table … restriction prevents the trigger from querying or modifying the table that the triggering statement is … modifying.
Chaining Pipelined Table Functions → To chain pipelined table functions tf1 and tf2 is to make the output of tf1 the input of tf2. For … example: SELECT * FROM TABLE(tf2(CURSOR(SELECT * FROM TABLE(tf1())))); The rows that tf1 pipes out … table functions are enabled for parallel execution, then each function runs in a different process (or … set of
Creating Pipelined Table Functions → A pipelined table function must be either a standalone function or a package function. PIPELINED … the pipelined table function for parallel execution by specifying the PARALLEL_ENABLE option … . AUTONOMOUS_TRANSACTION Pragma If the pipelined table function runs DML statements, then make it … . DETERMINISTIC Option (Recommended)
Table 2-5 Relational Operators → This table summarizes the relational operators. Table 2-5 Relational Operators Operator Meaning = equal
Passing CURSOR Expressions to Pipelined Table Functions → As Example 12-31 shows, the actual parameter for the cursor variable parameter of a pipelined table … includes a pipelined table function with two cursor variable parameters and then invokes the function … table function as an aggregate function, which takes a set of input rows and returns a single … COLUMN_VALUE, see Oracle Database
Fetching from Results of Pipelined Table Functions → You can associate a named cursor with a query that invokes a pipelined table function. Such a … statements in the first PL/SQL statement. In Example 12-31, assume that f and g are pipelined table … \" Example 12-31 Fetching from Results of Pipelined Table Functions DECLARE r SYS_REFCURSOR … ;... -- First PL/SQL statement (slower):
Chaining Pipelined Table Functions for Multiple Transformations → Chaining pipelined table functions is an efficient way to perform multiple transformations on data … . Note: You cannot run a pipelined table function over a database link. The reason is that the return … type of a pipelined table function is a SQL user-defined type, which can be used only in a single … type of a pipelined table
DML Statements on Pipelined Table Function Results → The \"table\" that a pipelined table function returns cannot be the target table of a DELETE … , INSERT, UPDATE, or MERGE statement. However, you can create a view of such a table and create INSTEAD OF
Pipelined Table Functions as Transformation Functions → A pipelined table function with a cursor variable parameter can serve as a transformation function … pipelined table function transforms each selected row of the employees table to two nested table rows, which … CURSOR Expressions to Pipelined Table Functions \". Example 12-30 Pipelined Table
Table 9-2 Compound Trigger Timing-Point Sections → created on a table or editioning view has at least one timing-point section in Table 9-2. If the trigger … repeated. If a timing-point section is absent, then nothing happens at its timing point. Table 9-2
Table 8-4 Finer and Coarser Caching Granularity → -Cached Functions Depend \" ). A session is performing a DML statement on a table or view on which a … it. In Example 8-40, assume that a table, config_tab, has a VPD policy that translates this query … Product_Descriptions table in the Order Entry ( OE ) sample schema: NAME NULL? TYPE … ) TRANSLATED_NAME NOT NULL NVARCHAR2(50)
This table summarizes the initialization parameters for PL/SQL compilation. → these parameters, see Table 1-2. Because a selection directive needs a BOOLEAN static expression, you
Assigning Set Operation Results to Nested Table Variables → To a nested table variable, you can assign the result of a SQL MULTISET operation or SQL SET … function invocation. The SQL MULTISET operators combine two nested tables into a single nested table. The … MULTISET operators, see Oracle Database SQL Language Reference. The SQL SET function takes a nested table … argument and returns
This table summarizes the PL/SQL reserved words. → recommended. For lists of PL/SQL reserved words and keywords, see Table D-1 and Table D-2, respectively.
Comparing Varray and Nested Table Variables to NULL → table variables to the value NULL with the \" IS [NOT] NULL Operator \", but not with the relational … Table Variables to NULL This example compares a varray variable and a nested table variable to NULL … Nested Table Variables to NULL DECLARE TYPE Foursome IS VARRAY(4) OF VARCHAR2(15); -- VARRAY type team … Foursome;
This table summarizes the PL/SQL reserved words. → these symbols: Dollar sign ($) Number sign (#) Underscore (_) Is not a reserved word (listed in Table
Assigning Null Values to Varray or Nested Table Variables → To a varray or nested table variable, you can assign the value NULL or a collection of the … same data type. Either assignment makes the variable . Example 5-9 initializes the nested table … -initializes it to a different non- value. Example 5-9 Assigning Null Value to Nested Table Variable … Live SQL: You can view and run this
This table show the possible trigger points and corresponding optional sections for a compound trigger… → this statement triggers a compound DML trigger that has all four timing-point sections in Table 9-2
This table gives the names and error numbers of the PL/SQL predefined exceptions. → them explicitly with the RAISE statement if they have names. Table 11-3 lists the internally defined … Exception DROP TABLE t; CREATE TABLE t (c NUMBER); CREATE PROCEDURE p (n NUMBER) AUTHID DEFINER IS