Alex Rivera | Logout

Microsoft T-SQL to Oracle SQL translation

Asked 2008-09-03T14:25:04.110
21

I've worked with T-SQL for years but I've just moved to an organisation that is going to require writing some Oracle stuff, probably just simple CRUD operations at least until I find my feet. I'm not going to be migrating databases from one to the other simply interacting with existing Oracle databases from an Application Development perspective. Is there are tool or utility available to easily translate T-SQL into Oracle SQL, a keyword mapper is the sort of thing I'm looking for.

P.S. I'm too lazy to RTFM, besides it's not going to be a big part of my role so I just want something to get me up to speed a little faster.

sql oracle-database t-sql
Edit
Report

1 Answer

2

The most important differences for plain T-SQL are:

  • NVL replaces ISNULL
  • SYSDATE replaces GETDATE()
  • CONVERT is not supported
  • Identity columns must be replaced with sequences <-- not technically T- or PL/ but just SQL

Note. I assume you do not use the deprecated SQL Server *= syntax for joins

@jodonell: The table you link to is a bit outdated, oracle has become somewhat more standards compliant after 9i supporting things like CASE and ANSI outer joins

answered 2008-09-03T14:52:21.313

Your Answer