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
https://www.sqlines.com/sql-server-to-oracle/day
DAY Function - SQL Server to Oracle Migration - SQLines Tools
In SQL Server you can use DAY function to get the day (an integer number) of the specified datetime. In Oracle you have to use EXTRACT(DAY FROM datetime)...
sql server to oracledayfunctionmigrationtools