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 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.