Collect – Oracle SQL Function

COLLECT is used with the CAST function to create a nested table of the specified column name and cast it to the type specified in the CAST function.

Example:

SELECT CAST(COLLECT(some_column) as some_type) FROM table_name;