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

is there equivalent in oracle array subselect if there more 1 row in subselect's results there still 1 row in final results?

e.g.:

select c.name, array(select order_id order o o.customer_id = c.id) customer c; 

will return 1 row per customer, second value in each returned row array of order_id's.

you can use cursor:

select c.name, cursor(select order_id order o o.customer_id = c.id) customer c; 

then database interface have way of getting results out of cursor result.