Generic way to convert SQL to oracle query statements.

Asked By janneya llison 10 points N/A Posted 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?

• Status: Open
• Question Views: 711
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Williams Todd 0 points N/A #160375

Generic way to convert SQL to oracle query statements.

Hello,

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.

About Williams Todd

Questions
4

Answers
143

Best Answers
18

• Vote Up 0 Vote Down

• Posted on - 02/14/2013
• Question Category: Oracle Database