Announce:SQL Conversion tool
From: JoyJoin <pr_at_joyjoin.com>
Date: 27 Aug 2003 17:33:04 -0700
Message-ID: <470e9d53.0308271633.12aa8692_at_posting.google.com>
Date: 27 Aug 2003 17:33:04 -0700
Message-ID: <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 Thu Aug 28 2003 - 02:33:04 CEST
