You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for table


1 to 20 of 23239 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Optimization and Tuning

Overview of Table FunctionsA 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Triggers

Mutating-Table RestrictionNote: 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.

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Optimization and Tuning

Chaining Pipelined Table FunctionsTo 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Optimization and Tuning

Creating Pipelined Table FunctionsA 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)

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Language Fundamentals

Table 2-5 Relational OperatorsThis table summarizes the relational operators. Table 2-5 Relational Operators Operator Meaning = equal

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Optimization and Tuning

Passing CURSOR Expressions to Pipelined Table FunctionsAs 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Optimization and Tuning

Fetching from Results of Pipelined Table FunctionsYou 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):

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Optimization and Tuning

Chaining Pipelined Table Functions for Multiple TransformationsChaining 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Optimization and Tuning

DML Statements on Pipelined Table Function ResultsThe \"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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Optimization and Tuning

Pipelined Table Functions as Transformation FunctionsA 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Triggers

Table 9-2 Compound Trigger Timing-Point Sectionscreated 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Subprograms

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)

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Language Fundamentals

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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Collections and Records

Assigning Set Operation Results to Nested Table VariablesTo 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Language Fundamentals

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.

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Collections and Records

Comparing Varray and Nested Table Variables to NULLtable 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;

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Language Fundamentals

This table summarizes the PL/SQL reserved words.these symbols: Dollar sign ($) Number sign (#) Underscore (_) Is not a reserved word (listed in Table

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Collections and Records

Assigning Null Values to Varray or Nested Table VariablesTo 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Triggers

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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Error Handling

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