|
Software Description:
|
About JoyJoin - SQL TRANSLATION HELPER, 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 <= (numeric constant value)" presentation to "top" representation. |
