List of Examples

3-1 How to Define a DataStream data type
3-2 How to Define the Type Body
3-3 How to Specify an ODI for an Object Type
3-4 How to Assign and Use OIDs
3-5 How to Create a Type
3-6 How to Instantiate a Type Object
3-7 How to Implement a Member Function
3-8 How to Implement Functions for Types Without a Simple Id Attributte
4-1 How to Define an Object Type
4-2 How to Define a "Greatest Common Divisor" Function
4-3 How to Implement Methods for an Object Type
4-4 How to Invoke Methods; General Syntax
4-5 How to Invoke Methods; SQL Syntax
4-6 How to Invoke Methods; General Syntax
4-7 How to use the SELF Build-In Paramenter
4-8 How to Set Variable Values
4-9 How to Create a Package Specification
4-10 How to Assert the Purity Level of a Type
4-11 How to Assert the Purity Level of a Package
4-12 How to Assert a Default Purity Level for All Type Methods and Package Procedures
4-13 How to Output Variable Values to the Terminal, for Debugging
4-14 How to Drop Packages and Tables
4-15 How to Recompile Packages
5-1 How to Create an Alias Library
5-2 How to Specify the Location of the Library Using an Environment Variable
5-3 How to Define the Body of a Package
5-4 How to Set the SID_DESC Entry in the Listener Configuration FIle
5-5 How to Update the Network Substrate Configuration File to Refer to External Procedures
5-6 How to Use Callbacks
6-1 How to Create a CLOB Attribute of a Type
6-2 How to Create a LOB Object Table
6-3 How to Create LOB Columns in a Table
6-4 How to Select a LOB Locator and Assign it to a Local Variable
6-5 How to Manipulate LOBs with PUT_LINE and GETLENGTH
6-6 Syntax of EMPTY_CLOB() and EMPTY_CLOB() Functions
6-7 How to Use EMPTY_BLOB() with SQL DML
6-8 How to Use EMPTY_CLOB() in PL/SQL Programs
6-9 How to Select a LOB from the Database into a Locator
6-10 How to Trim a CLOB
6-11 How to Define a PL/SQL External Procedure
6-12 How to Use Open and Close Code Block
7-1 How to Declare a New Table
7-2 How to Build a Text Domain Index
7-3 How to Use the Contains Operator
8-1 How to Create an Indextype
8-2 How to Drop an IndexType.
8-3 How to Comment an INDEXTYPE
8-4 How to Create a Domain Index
8-5 How to Change a Domain Index
8-6 How to Rename a Domain Index
8-7 How to Rebuild a Domain Index
8-8 How to Truncate a Domain Index
8-9 How to Drop a Domain Index
8-10 How to Get the Size of a UROWID Column
8-11 How to Use *_SECONDARY_OBJECTS Views
8-12 How to Use Local Domain Index Methods Within an Indextype
8-13 How to Create and Partition an Index
8-14 How to Create a Local Domain Index
8-15 How to Drop a Local Index Partition
8-16 How to Create a System-Partitioned Table
8-17 How to Insert Data into a System-Partitioned Table
8-18 How to Insert Data into a System-Partitioned Table Using DATAOBJ_TO_PARTITION
8-19 How to Insert Data into a Particular Partition of a Table
8-20 How to Split an Existing Table Partition
8-21 How to Issue DML Operations on System-Partitioned Tables
8-22 How to Query a System-Partitioned Table
9-1 How to Create an Operator
9-2 How to Drop an Operator; RESTRICT Option
9-3 How to Drop an Operator; FORCE Option
9-4 How to Add a Binding to an Operator
9-5 How to COMMENT an Operator
9-6 How to Create the Contains() Operator
9-7 How to Use the Operator Contains() in a Query
9-8 An Incorrect Use of the Operator Contains()
9-9 Operator Predicates
9-10 How to Use the Contains() Operator in a Simple Query
9-11 How to Use the Contains() Operator in a Complex Query
9-12 How to Use the Contains() Operator in a Multiple Table Query
9-13 How to Invoke Indextype Routines for the Contains() Operator Query
9-14 How to Use Operators Outside the WHERE Clause
9-15 How to Implement the Contains() Operator in Index-Based Functions
9-16 How to Bind the Contains() Operator to the Functional Implementation
9-17 How to Access Ancillary Data with the Contains() Operator
9-18 How to Compare Ancillary Data with the Contains() Operator
9-19 How to Implement Bindings for Computations
9-20 How to Evaluate an Ancillary Operator
9-21 How to Create an Ancillary Operator Binding
10-1 Three Predicate Forms that Trigger a Call to the Optimizer
10-2 How to Define a Statistics Type
10-3 How to Define a User-Defined Function
10-4 How to Call a Selectivity Function Using Literal Arguments
10-5 How to Call a Selectivity Function Using Non-Literal Arguments
10-6 How to Call a Cost Function Using Literal Arguments
10-7 How to Call a Cost Function Using Non-Literal Arguments
10-8 How to Define an Operator
10-9 How to Call an Index Cost Function Using Non-Literal Arguments
10-10 How to Create a Table with an Object Type Column
10-11 How to Associate Statistics with Columns for User-Defined Statistics
10-12 How to Associate Statistics with Data Types for User-Defined Statistics
10-13 How to Create an Indextype, an Index and an Operator for User-Defined Statistics
10-14 How to Associate Statistics with System-Managed Indextypes for User-Defined Statistics
10-15 How to Associate Statistics with User-Defined Operators for User-Defined Selectivity
10-16 How to Associate Statistics with Standalone Functions for User-Defined Selectivity
10-17 How to Associate Statistics with Package Functions for User-Defined Selectivity
10-18 How to Associate Statistics with Type Methods for User-Defined Selectivity
10-19 How to Associate Statistics with Default Selectivity for User-Defined Selectivity
10-20 How to Associate Statistics with User-Defined Operators for User-Defined Cost
10-21 How to Associate Statistics with Standalone Functions for User-Defined Cost
10-22 How to Associate Statistics with Package Functions for User-Defined Cost
10-23 How to Associate Statistics with Type Methods for User-Defined Cost
10-24 How to Associate Statistics with Default Cost for User-Defined Cost
10-25 How to Declare NULL Statistics Associations for Columns and Indexes
11-1 How User-Defined Aggregate Functions Work
11-2 How to Implement the ODCIAggregate Interface
11-3 How to Define a User-Defined Aggregate Function
11-4 How to Use SELECT Statement with User-Defined Aggregate Functions
11-5 How to Use HAVING Clause with User-Defined Aggregate Functions
11-6 How to Use other Query Options with User-Defined Aggregate Functions
11-7 How to Parallel-Enable a User-Defined Aggregate Function
11-8 How to Use External Memory to Store Aggregate Context
11-9 How to Use User-Defined Aggregates as Analytic Functions
11-10 How to Create Materialized Views
11-11 How to Enable Materialized Views for Query Rewrite
11-12 How to Create and Use a User-Defined Aggregate Function
12-1 How to Initialize OCI Handles
12-2 How to Retrieve Error Information Using OCIErrorGet()
13-1 How to Create a Collection Type
13-2 How to Store a Clob in a Table
13-3 How to Create a Function that Returns a Collection Type
13-4 How to Use a Collection Type in a Query
13-5 How to Declare a Pipelined Table Function with REF CURSOR Arguments
13-6 How to Use a Pipelined Table Function with REF CURSOR Arguments
13-7 How to Declare Pipelined Table Functions for the Interface Approach
13-8 How to Declare Pipelined Table Functions for the Native PL/SQL Approach
13-9 How to Implement a Pipelined Table Function for the Native PL/SQL Approach
13-10 How to Pipeline Function Results from One Function to Another
13-11 How to Query for AnyType Data
13-12 How to Implement the ODCITableDescribe() Method
13-13 How to Use Functions that Return AnyType
13-14 How to Build an Array of Attribute Positions and Save it in a Scan Context
13-15 How to Use a Table Function to Iteratively Retrieve Rows
13-16 How to Use Multiple Invokations of a Table Function
13-17 How to Define REF CURSOR Variables for Table Function Queries
13-18 How to Use a REF CURSOR Variable
13-19 How to Use a REF CURSOR Variable More Effectively
13-20 How to Declare a Table Function with Autonomous Transaction Pragma
13-21 How to Create a View over a Table
13-22 How an INSTEAD OF Trigger is Fired when a Row is Inserted into a View
13-23 How to Pass a Set of Rows to a PL/SQL Function in a REF CURSOR
13-24 How to Directly Pass Results from a Subquery to a Function
13-25 How to Pass a Set of Rows to a PL/SQL Function in a Several REF CURSOR Parameters
13-26 How to Invoke a Function that Uses Several REF CURSOR Parameters
13-27 How to Use REF CURSOR to Pass Return Values Between Table Functions
13-28 How to Explicitly Use a Query REF CURSOR as a Parameter for a Table Function
13-29 How to Use a REF CURSOR in a Callout
13-30 How to Specify Data Partitioning for a REF CURSOR Parameter
13-31 How to Implement the StockPivot() Function
13-32 How to Use a REF CURSOR to Generate a Table from Another Table
13-33 How to User a REF CURSOR to Scan and Insert
13-34 How to Use a REF CURSOR to Read a Set of External FIles
13-35 How to Control Input Data Streaming
13-36 How to Order the Input Stream
13-37 How to Load a Domain Index in Parallel
13-38 How to Merge the Results from Parallel Domain Index Loads
13-39 How to Invoke the Merging of Parallel Domain Index Loads
15-1 How to Create a Database User for the Power Demand Cartridge
15-2 How to Create the PowerGrid_Typ and NumTab_Typ Types for the Power Demand Cartridge
15-3 How to Create the PowerDemand_Typ Type for the Power Demand Cartridge
15-4 How to Implement the PowerDemand_Typ Type for the Power Demand Cartridge
15-5 How to Implement the Power_XXX_Func() Functions for the Power Demand Cartridge
15-6 How to Implement the Power_XXX() Functions for the Power Demand Cartridge
15-7 How to Create the power_idxtype_im Object Type for the Power Demand Cartridge
15-8 How to Register the Implementation of ODCIGetInterfaces() for ODCIIndexXXX() Functions for the Power Demand Cartridge
15-9 How to Register the Implementation of ODCIIndexCreate() for the Power Demand Cartridge
15-10 How to Register the Implementation of ODCIIndexDrop() for the Power Demand Cartridge
15-11 How to Register the Implementation of ODCIIndexStart() for Specific Queries for the Power Demand Cartridge
15-12 How to Register the Implementation of ODCIIndexStart() for Any Queries for the Power Demand Cartridge
15-13 How to Register the Implementation of ODCIIndexFetch() for the Power Demand Cartridge
15-14 How to Register the Implementation of ODCIIndexStart() for Power Demand Cartridge
15-15 How to Register the Implementation of ODCIIndexInsert() for Power Demand Cartridge
15-16 How to Register the Implementation of ODCIIndexDelete() for Power Demand Cartridge
15-17 How to Register the Implementation of ODCIIndexUpdate() for Power Demand Cartridge
15-18 How to Register the Implementation of ODCIIndexGetMetadata() for Power Demand Cartridge
15-19 How to Create the Package power_pkg for the Power Demand Cartridge
15-20 How to Create the Indextype power_idxtype for the Power Demand Cartridge
15-21 How to Create the Statistics Table PowerCartUserStats for the Power Demand Cartridge
15-22 How to Create the power_statistics Object Type Definition for Power Demand Cartridge
15-23 How to Register the Implementation of ODCIGetInterfaces() for ODCIStatsXXX() Functions for Power Demand Cartridge
15-24 How to Register the Implementation of ODCIStatsCollect() for PowerDemamnd_Type Columns for Power Demand Cartridge
15-25 How to Register the Implementation of ODCIStatsDelete() for PowerDemand_Typ Columns for the Power Demand Cartridge
15-26 How to Register the Implementation of ODCIStatsCollect() for power_idxtype Domain Indexes for the Power Demand Cartridge
15-27 How to Register the Implementation of ODCIStatsDelete() for power_idxtype Domain Indexes for the Power Demand Cartridge
15-28 How to Implement a get_selectivity() Function for the Power Demand Cartridge
15-29 How to Register the Implementation of ODCIStatsSelectivity() for Specific Queries for the Power Demand Cartridge
15-30 How to Register the Implementation of ODCISIndexCost() for Specific Queries for the Power Demand Cartridge
15-31 How to Register the Implementation of ODCIStatsIndexCost() for Any Queries for the Power Demand Cartridge
15-32 How to Register the Implementation of ODCIStatsFunctionCost() for the Power Demand Cartridge
15-33 How to Associate the ODCIStatsXXX() Methods with the Database Objects for the Power Demand Cartridge
15-34 How to Analyze the Database Objects for the Power Demand Cartridge
15-35 How to Create the PowerDemand_Tab Table for the Power Demand Cartridge
15-36 How to Populate the PowerDemand_Tab Table for the Power Demand Cartridge
15-37 How to Compute Total Grid Demand, and Maximum and Minimum Cell Demands for the Power Demand Cartridge
15-38 How to Make Equality Queries Without and Index for the Power Demand Cartridge
15-39 How to Create an Index on the Sample Column of the PowerDemand_Tab Table for the Power Demand Cartridge
15-40 How to Make Equality Queries with an Index for the Power Demand Cartridge
16-1 How to Implement the EQUALS Operator
16-2 How to Implement the LESS THAN Operator
16-3 How to Implement the GREATER THAN Operator
16-4 How to Create the EQUALS Operator
16-5 How to Create the LESS THAN Operator
16-6 How to Create the GREATER THAN Operator
16-7 How to Create a PSBTREE Index Type
16-8 How to Create the Implementation Body for PBSTREE
16-9 How to Implement ODCIGetInterfaces() for PBSTREE in PL/SQL
16-10 How to Implement ODCIIndexCreate() for PBSTREE in PL/SQL
16-11 How to Implement ODCIIndexDrop() for PBSTREE in PL/SQL
16-12 How to Implement ODCIIndexAlter() for PSBTREE in PL/SQL
16-13 How to Implement ODCIIndexUpdPartMetadata() for PSBTREE in PL/SQL
16-14 How to Implement ODCIIndexExchangePartition() for PSBTREE in PL/SQL
16-15 How to Register the Implementation of ODCIIndexInsert()
16-16 How to Register the Implementation of ODCIIndexDelete()
16-17 How to Register the Implementation of ODCIIndexUpdate()
16-18 How to Register the Implementation of ODCIIndexStart()
16-19 How to Register the Implementation of ODCIIndexFetch()
16-20 How to Register the Implementation of ODCIIndexClose()
16-21 How to Define Mappings for the Object Type and Its Null Value
16-22 How to Keep the Scan State During Fetching Calls.
16-23 How to Implement a Common Error Processing Routine in C
16-24 How to Implement ODCIIndexInsert() for PSBTREE in C
16-25 How to Implement ODCIIndexDelete() for PSBTREE in C
16-26 How to Implement ODCIIndexUpdate() for PSBTree in C
16-27 How to Implement ODCIIndexStart() for PSBTREE in C
16-28 How to Implement ODCIIndexFetch() for PSBTREE in C
16-29 How to Implement ODCIIndexClose() for PSBTREE in C
16-30 How to Implement the Indextype for PSBTREE
16-31 How to Create and Populate a Partitioned Table for PSBTREE
16-32 How to Create a PSBTREE Index on a Column
16-33 How to Use PSBTREE Operators in a Query
17-1 How to Make SQL Declarations for C Implementation of ODCITableXXX() Methods
17-2 How to Implement ODCTableXXX() Methods in C
17-3 How to Make SQL Declarations for Java Implementation of OCITableXXX() Methods
17-4 How to Implement the ODCITableXXX() Methods in Java
21-1 Using Statistics Functions in an Extensible Optimizer Interface