For XML Path Equivalent in Oracle For String Aggregation

For all of us that perform data migrations, sometimes we cross with specific DBMS functionalities. 
For instance, the SQL Server Trasact-SQL FOR XML PATH, which can be implemented in Oracle PL/SQL this way: For XML Path Equivalent in Oracle For String Aggregation

 ./M6