SQL & PL/SQL

Dear All,

Could you please help me in this below query to get only one concatenated row for DEPENDENTS value.

/* Formatted on 2017/04/26 10:51 (Formatter Plus v4.8.8) */

SELECT a.person_code, a.last_name, first_name, listagg (c.depend_name, ',') within GROUP (ORDER BY c.depend_name) as dependents

FROM fam\_person a, fam\_person\_communication b, cq\_dependents c

WHERE a.person_id = b.person_id

 AND a.person\_code = c.person\_code

 AND a.person\_code = '60050010'

SROUP BY a.person_code, a.last_name, first_name, c.depend_name

Output of the above query:

Required Output as like below:

Below is the Result of FAM_PERSON_COMMUNICATION table.

Below is the Result of CQ_DEPENDENTS table.

Please suggest me to correct the query.

I am on Oracle 11g 11.2.0.2.0 - 64bit Production

Thanks.