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>


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

Original text of this message