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.