globalwm2
asked on
Oracle SQL: Create Nested Table Dataset (like COLLECT)
I have a table join where there are multiple rows per my join column name. Using the COLLECT function on each column:
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 ?
For example:
col1, col2
subcol1, subcol2
An example of this can been seen by the USER_DATA column in:
I'm just looking for two columns though.
SELECT inventory_item_id, COLLECT (promodisplayorder) AS display_order, COLLECT (promoname) AS promo_name
FROM WEBSTAGE_promo
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 ?
For example:
col1, col2
subcol1, subcol2
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER