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
table → The Oracle database table name that contains the row and column.
Table of Contents → Index 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 22.214.171.124 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
Table Data Source Synchronization → Table 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:
Table (ORAMD_TABLE) Attributes → Feedback 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
Example: Describing a Table → Feedback 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
Table of Contents → Contents 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
Table of Contents → Contents 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
Parallel Execution: Partitioning and Clustering → Partitioning 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
Handling Exceptions in Table Functions → Exception 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
Performing DML Operations Inside Table Functions → A 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.
Parallel Execution of Leaf-level Table Functions → To 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
Input Data Streaming for Table Functions → The 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
Querying Table Functions → Pipelined 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
Declarations of Pipelined Table Functions → You 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
Transient and Generic Types → can also store encapsulated data of a variety of underlying types in one table column of type
Table of Contents → Table 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
Implementing the Native PL/SQL Approach → In 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
Performing DML Operations on Table Functions → Table 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
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
Parallel Table Functions → For 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