SEARCH
Sign up to our Newsletter No Spam Guaranteed
Click here to WIN
Free Oracle Magazine
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;
Add your comments or share tips on Collect
Top
