Create a composite object
Returns a composite object containing the serialization of each argument. The total serialized length of the arguments may not exceed 255.
A composite object
SQLState | Error Code | Error Text | Description |
---|---|---|---|
22026 | FT001 | Length limit of composite exceeded. | The sum of length of the components exceeds 255. |
Get second component of a composite of two integers. See reference page for composite_ref.
SQL> select composite_ref (composite (10,20), 1); callret VARCHAR _______________________________________________________________________________ 20 1 Rows. -- 6 msec.
composite_ref . The chapter Composite Data Type for a definition of properties of composite objects.