The easiest method to do this is to run this query on Oracle and see which functions error out.

Use Google to find the Oracle equivalent. (for example: convert sql server versus oracle).

And check if Oracle supports CTEs 🙂