Post reply

script to convert sql server query to oracle query

  • July 18, 2007 at 7:23 pm

    #177661

    Hi All,

    Does any one have script to convert sql server query to oracle query.

     

    Please i need help really

    Thanks

  • July 20, 2007 at 11:04 pm

    #721316

    I know of no automated tool that does this. Most of the work is dealing with the functions for which you need to find the Oracle equivalent. It does help if the query uses the join syntax as opposed to the old style + operator for left and right joins. It does help if you show the query.

  • July 23, 2007 at 1:44 pm

    #721656

    Download Oracle XE and Install.  Create a procedure out of your query. 

    XE has tools to convert SQL Server DB's to Oracle DB's.  It won't do a Great job, but actually works some times.

  • April 22, 2011 at 5:14 pm

    #1315062

    Today i encountered with the same problem and don't know how to write an update the select update query in Oracle, then i found a software SwisSQL. It makes my life paradise. http://www.swissql.com/products/sql-translator/sqlone-consolejavadownload.html

    Just Copy your T-SQL and it will convert it to PL-SQL and in so many other languages.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply