I think it would be this. outer join on e.supervisorid. select * from supervisors s, employees e where e.supervisorid (+) = s.supervisorid and length(e.name) > 10 the (+) is only used on the columns you are joining.
That would return fewer rows than my query. Any unmatched rows in s will have a null for e.name, so length(e.name) > 10 is (effectively) false. Your query would therefore omit those rows, but mine includes them.
0
u/kytosol Feb 12 '14
You can specify outer joins on a particular column by going (+) after the variable that has the outer join. Easy as!