N/APosted on - 01/31/2013
When developing a system that is not supposed to be depended on specific implementation of SQL by a database management system it is a requirement that one sticks to standard SQL. However, sometimes you find existing systems that you need to convert from one database management system to another. Is there for example a generic way to convert SQL to oracle query statements?
Generic way to convert SQL to oracle query statements.
There is no script that will translate SQL queries to Oracle but the only way to solve this issue is to learn the syntax difference Between Oracle SQL and SQL. Please follow this link for more information.
OracE.txt has an example that shows you the SQL syntax used by MySQL/SQL/Oracle and MS Access: SQL creates a FOREIGN KEY on the "P_Id" column when the "Orders" table is created.
You can also consult this site for some good information.
I hope this is useful.