JoyJoin wrote:

> Hi all,
> I have developed a SQL conversion tool named 'JoyJoin'.
> It converts Oracle SQL to ANSI SQL.
>
> eg. This tool converts:
>
> select a.f1,b.f2 from table1 a , table2 b where a.f1 = b.f1(+)
> to
> select a.f1,b.f2 from table1 a left join table2 b on a.f1 = b.f1
>
> select decode(a.f1,'-1','True','False') from table1 a
> to
> select (case a.f1 when '-1' then 'True' else 'False' end) from table1 a
>
> select a.field1 from table1 where rownum <= 10 order by a.field1
> to
> select top 10 a.field1 from table1 order by a.field1
>
> select '1' || '2||3' from dual
> to
> select '1' + '2||3'
>
>
> Dowdload and try it at :
> http://www.joyjoin.com
>
> You can use all features of the product until 31 Jan 2004.
>
> Thank you.

How do you convert Oracle to ANSI SQL when:

A) There is no such thing as ANSI SQL. Perhaps you mean TransactSQL.
and
B) Oracle, as of 9i, has and uses all of the syntaxes you are trying to
convert? Oracle is both ISO and ANSI compliant. ANSI joins are fully
supported.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)