https://www.sqlines.com/sql-server-to-oracle/stuff_select_for_xml
STUFF and SELECT FOR XML PATH - SQL Server to Oracle Migration - SQLines Tools
In SQL Server, STUFF with SELECT FOR XML PATH statement is widely used to concatenate strings from multiple rows into a single row value. Consider a sample...
stuff and select for xml pathsql server to oracle