Assume this following SQL statement will get agency name
The search result is as bellows:
If we would like to concatenate multiple agencies into one row, we need to make good use of LISTAGG function.
Therefore, the SQL statement will modify as following:
But the agency name's characters are broken
Owing to agency column's data type is NVARCHAR2, LISTAGG function cannot handle NVARCHAR2 properly
So you need to cast agency to a char to fix this problem
Then we can get the expected result: