I'm connected to an Oracle Database (11g Release 2 - 18.104.22.168).
I'd like to "flatten"/"merge" all rows with the same ID, pretty much as is well delineated here: https://www.w3resource.com/mysql/aggregate-functions-and-grouping/aggregate-functions-and-grouping-group_concat.php
However, in this example the "concatenation" is applied only to one field/column; I'd want to apply it to several fields/columns.
Also, I'd only want to concatenate unique/distinct entries (in the above example that would be
P002 | CA003
instead of the duplication
P002 | CA003,CA003