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 12391 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


User's Guide, 9i Release 2 (9.2.0.2)

Job and Event Scripts

tableThe Oracle database table name that contains the row and column.

Spatial User's Guide and Reference, 9i Release 2 (9.2.0.2)

Table of Contents

Table of ContentsIndex Table Definition 2.5.3 R-Tree Index Sequence Object 2.6 Unit of Measurement Support 3 Loading … Support 5.4 Coordinate Systems Data Structures 5.4.1 MDSYS.CS_SRS Table 5.4.1.1 Well-Known Text … (WKTEXT) 5.4.2 MDSYS.SDO_ANGLE_UNITS Table 5.4.3 MDSYS.SDO_DIST_UNITS Table 5.4.4 MDSYS.SDO_DATUMS … Table

Database, 9i Release 2 (9.2.0.2)

Table Data Source Synchronization

Table Data Source SynchronizationTable Data Source Synchronization The Ultra Search crawler crawls database tables in the main … crawling of table sources. Using this logging mechanism, only newly updated documents are revisited … , make sure that the Ultra Search instance schema has the 'create any table' and 'create any trigger … provided to create the following:

Objects for OLE, 9i Release 2 (9.2.0.2)

Table (ORAMD_TABLE) Attributes

Table (ORAMD_TABLE) AttributesFeedback Table (ORAMD_TABLE) Attributes ORAMD_TABLE Attributes Attribute Name Value Type Description … Boolean is the table typed? IsTemporary Boolean is the table temporary? Duration String duration … Integer tablespace the table resides in IsClustered Boolean is the table clustered? IsPartitioned

Objects for OLE, 9i Release 2 (9.2.0.2)

Example: Describing a Table

Example: Describing a TableFeedback Example: Describing a Table See OraMetaData Schema Definitions. Dim OraSession As OraSession Dim … count of attributes belonging to the table MsgBox NumberOfAttributes & OraMetaData.Count 'Attribute can … of OraMDAttribute, the following shows 'the Value of property "IsClustered" for the table MsgBox "Is

interMedia Annotator User's Guide, 9i Release 2 (9.2.0.2)

Table of Contents

Table of ContentsContents List of Examples List of Figures List of Tables Title and Copyright Information Send Us Your Comments Preface Audience Documentation Accessibility Organization Related Documentation Conventions 1 Introduction to Oracle inter Media Annotator 1.1 Purpose 1.2 Operations Overview 1.3 Prerequisites Part I Oracle inter Media Annotator Engine 2 Getting Started with Oracle inter Media Annotator 2.1

interMedia Java Classes User's Guide and Reference, 9i Release 2 (9.2.0.2)

Table of Contents

Table of ContentsContents List of Examples Title and Copyright Information Send Us Your Comments Preface Audience Documentation Accessibility Organization Related Documentation Conventions 1 Introduction 1.1 Oracle inter Media Objects 1.2 Audio Concepts 1.2.1 Digitized Audio 1.2.2 Audio Components 1.3 Media Concepts 1.3.1 Digitized Media Data 1.3.2 Media Components 1.4 Image Concepts 1.4.1 Digitized Images 1.4.2 Image

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Pipelined and Parallel Table Functions

Parallel Execution: Partitioning and ClusteringPartitioning and clustering are easily confused, but they do different things. For example, sometimes partitioning can be sufficient without clustering in parallel execution. Consider a function SmallAggr that performs in-memory aggregation of salary for each department_id, where department_id can be either 1, 2, or 3. The input rows to the function can be partitioned by HASH on department_id such

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Pipelined and Parallel Table Functions

Handling Exceptions in Table FunctionsException handling in table functions works just as it does with ordinary user-defined functions … exception raised within a table function is handled, the table function executes the exception … the exception is cleared, execution proceeds normally. An unhandled exception in a table function causes the parent transaction

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Pipelined and Parallel Table Functions

Performing DML Operations Inside Table FunctionsA table function must be declared with the autonomous transaction pragma in order for the function … not shared by other processes. Use the following syntax to declare a table function with the … AUTONOMOUS_TRANSACTION; BEGIN... END; During parallel execution, each instance of the table function creates an independent transaction.

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Pipelined and Parallel Table Functions

Parallel Execution of Leaf-level Table FunctionsTo use parallel execution with a leaf-level table function--that is, a function to perform a … return the records they contain. To provide work for a REF CURSOR, you might first create a table and … populate it with the filenames. A REF CURSOR over this table can then be passed as a parameter to … the table function

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Pipelined and Parallel Table Functions

Input Data Streaming for Table FunctionsThe way in which a table function orders or clusters rows that it fetches from cursor arguments is … statement, the ORDER BY clause globally orders the entire data set. In a table function, the ORDER BY … clause orders the respective rows local to each instance of the table function running on a slave. The

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Pipelined and Parallel Table Functions

Querying Table FunctionsPipelined table functions are used in the FROM clause of SELECT statements in the same way … rows are retrieved by Oracle iteratively from the table function implementation. For example: SELECT … x.Ticker, x.Price FROM TABLE(StockPivot( CURSOR(SELECT * FROM StockTable))) x WHERE x.PriceType='C … '; Note: A table

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Pipelined and Parallel Table Functions

Declarations of Pipelined Table FunctionsYou declare a pipelined table function by specifying the PIPELINED keyword. This keyword indicates … that the function will return rows iteratively. The return type of the pipelined table function must … be a collection type (a nested table or a varray). The following example shows declarations of … pipelined table

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Pipelined and Parallel Table Functions

Transient and Generic Typescan also store encapsulated data of a variety of underlying types in one table column of type

Database, 9i Release 2 (9.2.0.2)

Ultra Search Table of Contents

Table of ContentsTable of Contents Part I Concepts What's New in Ultra Search Ultra Search Overview Ultra Search … Process Ultra Search on Real Application Clusters Using the Remote Crawler Table Data Source

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Pipelined and Parallel Table Functions

Implementing the Native PL/SQL ApproachIn PL/SQL, the PIPE ROW statement causes a table function to pipe a row and continue processing … . The statement enables a PL/SQL table function to return rows as soon as they are produced. (For … ) statement pipelines data out of the PL/SQL table function. The PIPE ROW statement may be used only in the … body of pipelined table

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Pipelined and Parallel Table Functions

Performing DML Operations on Table FunctionsTable functions cannot be the target table in UPDATE, INSERT, or DELETE statements. For example … ; INSERT INTO f(...) VALUES ('any', 'thing'); However, you can create a view over a table function and … FROM TABLE(GetBooks('data.txt')) x; The following INSTEAD OF trigger is fired when the user inserts a … be defined

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Pipelined and Parallel Table Functions

Inputting Data with Cursor Variables* FROM TABLE(f(CURSOR(SELECT empno FROM tab))); In the preceding example, the CURSOR keyword is … invoked as follows: SELECT * FROM TABLE(g(CURSOR(SELECT empno FROM tab), CURSOR(SELECT * FROM emp)); You … can pass table function return values to other table functions by creating a REF CURSOR that … iterates over

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Pipelined and Parallel Table Functions

Parallel Table FunctionsFor a table function to be executed in parallel, it must have a partitioned input parameter … . Parallelism is turned on for a table function if, and only if, both the following conditions are met: The