While attending a recent Windows Azure Quick Start, the presenter, Mike Benkovich (@mbenko) happened to show a table on his site with this keyword comparison between SQL Server and Oracle so I wanted to pass it a long.
A list of comparable functions for SQL Server or Oracle developers. Check out Mike’s site: http://www.benkotips.com/pages/TSQLvsOracleKeywords.aspx for this helpful list. While not exhaustive, it a one-stop shop for many of the most commonly used functions in SQL Server and their equivalent in Oracle.
You are an experienced SQL Server developer who now needs to pull data from Oracle or work with Oracle SQL to load Analysis Services or in Integration Services. Some things are the same, but you want to find the equivalent of PATINDEX in Oracle.