Re: Announce:SQL Conversion tool

Well done (and probably very useful in certain situations), but I prefer the readable version...!

ETA pr_at_joyjoin.com (JoyJoin) wrote in message news:<470e9d53.0308271633.12aa8692_at_posting.google.com>...
> 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
>
> Dowdload and try it at :
> http://www.joyjoin.com
>
> Thank you.
Received on Mon Sep 01 2003 - 10:31:58 CEST