I'm getting strange results when using the "Convert to ANSI Join Syntax" and "Convert to Oracle Join Syntax" options.
Consider this simple query:
SELECT a.col1
, b.col2
FROM a
JOIN b ON b.id1 = a.id1;
Refactor to Oracle join gives this result:
SELECT a.col1
, b.col2
FROM a
, b;
The other way around, with this query:
SELECT a.col1
, b.col2
FROM a
, b
WHERE b.id1(+) = a.id1;
Refactor to ANSI join gives this result:
SELECT a.col1
, b.col2
FROM a
CROSS JOIN b
WHERE (b.id1 /(+)/
) = a.id1;
Both results are clearly wrong.
Kind regards,
Remco