When doing outer join on multiple tables or two tables on multiple conditions in Oracle, if you are using (+) operator, you must use it in all of these conditions. If you do not, then Oracle Database will return only the rows resulting from a simple join, but without a warning or error to advise … Continue reading A subtle detail of outer join →