The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
--all of these queries return data type errors
--number data type error listed above
SELECT setid, collect(manager_id) as manager
from dept_tbl
group by setid;
--number data type error listed above
SELECT setid, cast(collect(manager_id) as number(7,2)) as manager
from ps_dept_tbl
group by setid;
--number data type error listed above
SELECT setid, cast(collect(cast(manager_id as number(7,2))) as number(7,2)) as manager
from ps_dept_tbl
group by setid;
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
this isn't as efficient as the options above, but it doesn't require construction of extra objects
select setid, RTRIM(EXTRACT(XMLAGG(XMLEL
from dept_tbl
group by setid