Here's how to translate the SQL Server XML Path into Oracle string aggregation:
For XML Path Equivalent in Oracle For String Aggregation
./M6
For XML Path Equivalent in Oracle For String Aggregation
./M6
Software related information one might find useful.