Oracle equivalent of PostgreSQL's sub-select to array?

AL

New Member
Is there an equivalent in Oracle to get an array from a subselect so if there is more than one row in the subselect's results there will still only be one row in the final results?e.g.:\[code\]select c.name, array(select order_id from ORDER o where o.customer_id = c.id)from CUSTOMER c;\[/code\]Will only return one row per CUSTOMER, where the second value in each returned row is an array of order_id's.
 
Top