The collection-derived table clause on row types

The collection-derived table clause allows you to create a collection-derived table from a row-type column.

This clause has the following syntax:
TABLE(:row_var)

The variable row_var is a row host variable. It can be either a typed or untyped row host variable but you must declare it beforehand.

For more information about the syntax of the collection-derived table clause, see the description of the collection-derived table segment in the Informix® Guide to SQL: Syntax.