JoyJoin - SQL TRANSLATION HELPER 1.01
License: Shareware Date: Jun 7, 2003 Size: 479.8KB
Information:
This tool translates Oracle SQL statements into non-Oracle RDBMS statements. As an example, this translates "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."
It can also convert Oracle-specific functions to RDBMS functions, in accordance with user settings. It can delete "from" clauses when the referenced table is "dual," and it handles the conversion of "rownum |
