COLLECTION ITERATOR (CONSTRUCTOR FETCH)

Description

Used with table functions

Versions

This operation was introduced in Oracle 8.1.5

This operation is implemented in the following versions

Example

This example was developed using Oracle 9.2.0.1 on Windows 2000

This example requires the following type definition

    CREATE OR REPLACE TYPE ty1 AS TABLE OF NUMBER;
    /

The table does not need to be analysed

The statement

    SELECT * FROM TABLE (ty1 (1,2,3,4));

generates the following execution plan

0     SELECT STATEMENT Optimizer=CHOOSE
1   0   COLLECTION ITERATOR (CONSTRUCTOR FETCH)