You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

how to concat one column and multiple values together?

edited Jul 29, 2024 8:57AM in Compensation 2 comments

Summary:

I have one query which returns all benefit plans under one employee now i want to fetch all dependent plans name in single row which will be comma separated how to get this? in query want to concat PL.NAME Field

Content (please ensure you mask any confidential information):


SELECT rel_papf.person_number DEPENDENT_PERSON_NUMBER,
ppnf.display_name DEPENDENT_NAME,
'DOB is missing' DEPENDENT_DOB,
papf.person_number ASSOCIATE_NUMBER,
(SELECT NAMEFROM HR_ORGANIZATION_UNITS_F_TL haouf
WHERE organization_id = ASSIGN.business_unit_id
AND TRUNC(SYSDATE) BETWEEN haouf.effective_start_date AND haouf.effective_end_date

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!