I have a table join where there are multiple rows per my join column name. Using the COLLECT function on each column:
SELECT inventory_item_id, COLLECT (promodisplayorder) AS display_order, COLLECT (promoname) AS promo_name
GROUP BY inventory_item_id)
will roll-up these values - each in a nested table (single column). Is there a way to have a single column with a double-column nested table ?
An example of this can been seen by the USER_DATA column in:
select * from wf_deferred
I'm just looking for two columns though.