This content has been marked as final. Show 2 replies
This is the forum for Oracle's SQL Developer tool, not for general SQL and PL/SQL questions. Questions like this will get a better response in the PL/SQL and SQL forum.
Having said that, this is a limitation of oracle's older outer join syntax. Outer joins can be rewritten using UNION and (apart from upgrading to a more recent version of oracle) that is probably your only option.
Ok, I'll post it under Oracle Database
Anyway, thanks for the suggestion.