Name
composite_ref — get member of a composite object
Synopsis
integer composite_ref ( |
in c any , |
in nth integer ); |
Description
composite_ref returns the
nth element of the
composite. The index is 0 based.
Parameters
nth
integer
Return types
The type returned is the type of the composite member referred to.
Errors
Table24.14.Errors signalled by
composite_ref
| 22023 | FT002 | composite expected for composite ref | |
| 22003 | FT003 | composite index out of range %d for length %d |
Examples
Example24.46.Simple example
Get first member of a composite consisting of VARCHAR values.
SQL> select composite_ref (composite ('Miles','Herbie','Wayne','Ron','Tony'), 0);
callret
VARCHAR
_______________________________________________________________________________
Miles
1 Rows. -- 4 msec.
See Also
The Composite Data Type for a definition of the properties of composite objects.
The function composite .