Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

script to convert sql server query to oracle query Expand / Collapse
Author
Message
Posted Wednesday, July 18, 2007 7:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 18, 2007 7:21 PM
Points: 1, Visits: 1

Hi All,

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

 

Please i need help really

Thanks

Post #383068
Posted Friday, July 20, 2007 11:04 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 2:19 AM
Points: 542, Visits: 2,138
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.
Post #383924
Posted Monday, July 23, 2007 1:44 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, January 6, 2012 2:39 PM
Points: 954, Visits: 683

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.

Post #384339
Posted Friday, April 22, 2011 5:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 22, 2011 5:10 PM
Points: 1, Visits: 19
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.
Post #1097670
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse