YOUR AD GOES HERE

select from collect-aggregate function

Published 03, Feb 2026

OraPython


Description:
Topic: select * from collect(..)
select t.region_id, tt.*
from (select t.region_id,
collect(t.country_id
order by t.country_id) as country_ids
from (select t.region_id, t.country_id
from hr.countries t
where t.region_id = 20
) t
group by t.region_id
) t, table(t.country_ids) tt;

Releted More Videos

  • Sorry!!! Nothing to show

You May Also Like

YOUR AD GOES HERE

YOUR AD GOES HERE