MySQL Forums
Forum List  »  Oracle

difference in SQL syntax
Posted by: manish singh
Date: November 08, 2004 03:26AM

iam currently working on integrating a mysql server with the currently
existing group of oracle dbs
the new mysql server will behave as a central location for all the data in
the oracle dbs
besides this the new system should work the same way as the old one

that is for eg
specifc queries are written to generate data from multiple tables in the oracle system
now these queries whould also work on the new mysql server.

my first question
1) is there any difference in the sql syntax of oracle and mysql
if yes then
2) are there any resources on the net which would explain the difference between
the two syntactically and from the data type point of view so that i can modify the
current queries to run on mysql.


Options: ReplyQuote

Written By
difference in SQL syntax
November 08, 2004 03:26AM
November 16, 2004 06:33PM
August 23, 2006 01:40AM
October 15, 2006 11:09PM
October 26, 2006 05:33AM
November 06, 2006 11:45PM
October 31, 2007 10:27PM
September 28, 2007 07:17AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.