We had been using the below statement in a report to check status dates for resumes. With more and more people applying for the same position, HR would like the report changed so that all dates for each status are printed on the same line/column in the output.
SELECT
.
.
.
.
select ias.status_change_date
from per_assignment_status_types past,
irc_assignment_statuses ias
where past.assignment_status_type_id = ias.assignment_status_type_id
and ias.assignment_id = asg.assignment_id
and past.user_status = 'Resume Reviewed'
and rownum = 1
FROM
.
.
WHERE
.
.
Is there some way to modify the subqueries to that it will concatenate the rows when it returns multiple records or will I need to create a function that does this for me? I was trying to avoid creating a function as we would need to call it about 20 times per record. Thanks for your help.