Hello,
Need help for concatenating multiple row values of a column into single row.
In SQL listagg function is working but when I am using in Report Builder its showing :
I am using in SELECT clause
SELECT
listagg(nvl(hcp.phone_area_code,'')||'-'||nvl(hcp.phone_country_code,'')||'-'||nvl(hcp.phone_number,''),',') WITHIN GROUP (ORDER BY hcp.phone_number ASC)
INTO
l_ph_num
FROM
..........