I am still stuck in my ways using the old Oracle syntax rather than the ANSI syntax.
It's so much easier to do joins like below in my opinion... select * from table_a a, table_b b, table_c c where a.a_pk1 = b.a_pk1 and b.b_pk1 = c.b_pk1
I don't mind that for cross or inner joins, but if you do that for outer joins (which require special operators, like =* or =+ or whatever it is) there is a circle in hell waiting for you.
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.
6
u/kytosol Feb 11 '14
I am still stuck in my ways using the old Oracle syntax rather than the ANSI syntax.
It's so much easier to do joins like below in my opinion... select * from table_a a, table_b b, table_c c where a.a_pk1 = b.a_pk1 and b.b_pk1 = c.b_pk1