How to produce Ansi-SQL Code instead of Oracle?

michellenweiter · Post by **michellenweiter** » Fri 13 Mar 2009 12:58

Hello,

Is there a way to let the ODAC and Developer produce the standard Ansi-SQL Code instead of the Oracle syntax?

Even if I write a query in Toraquery in an Ansi-SQL and then save the query after editing it using the builder, ODAC turns the syntax to the Oracle-SQL and don't keep the Ansi syntax.

When will the Ansi-SQL-Syntax be supported?

thanks a lot for your help
mitch

Duke · Post by **Duke** » Thu 26 Mar 2009 12:40

Could you please give us an example of code that after being edited in Query Builder changed its syntax?

michellenweiter · Post by **michellenweiter** » Wed 08 Apr 2009 14:21

Here is an example with the SQL-ansi syntax. With this in the ORAQuery, you can start the query, but if you try to open the Builder, you have an error.

select * from emp e
join dept d on (e.deptno = d.deptno)

michel

Duke · Post by **Duke** » Mon 13 Apr 2009 07:49

Indeed, Query Builder generates only native Oracle joins. This is for compatibility with earlier Oracle server versions.

In the next version we'll add ANSI syntax support. But I cannot tell you anything about the terms right now.