How to produce Ansi-SQL Code instead of Oracle?

How to produce Ansi-SQL Code instead of Oracle?

Postby 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
michellenweiter
 
Posts: 29
Joined: Thu 09 Jun 2005 06:23
Location: Bern, Switzerland

Postby 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?
Duke
Devart Team
 
Posts: 476
Joined: Fri 29 Oct 2004 09:25

Postby 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
michellenweiter
 
Posts: 29
Joined: Thu 09 Jun 2005 06:23
Location: Bern, Switzerland

Postby 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.
Duke
Devart Team
 
Posts: 476
Joined: Fri 29 Oct 2004 09:25


Return to dbForge for Oracle