Source
SnowConvert AI - General Functional Differences
This message is reported when a Correlated Subquery (subquery that refers to a column from the outer query) is located. This type of subqueries can, in some cases, present some functional differences in Snowflake (Working with Subqueries).
SnowConvert AI - Oracle - Built-in functions
This section shows equivalents between functions in Oracle and in Snowflake.