difference in SQL syntax
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.
thanks
Subject
Views
Written By
Posted
difference in SQL syntax
15383
November 08, 2004 03:26AM
10842
November 16, 2004 06:33PM
4254
August 23, 2006 01:40AM
5661
October 15, 2006 11:09PM
4007
October 26, 2006 05:33AM
4152
November 06, 2006 11:45PM
4189
October 31, 2007 10:27PM
4184
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.