Oracle: SELECT * FROM tablea a, tableb b WHERE a.fielda(+)=b.fieldb -- what is (+)? Oracle: SELECT * FROM tablea a, tableb b WHERE a.fielda(+)=b.fieldb -- what is (+)? sql sql

Oracle: SELECT * FROM tablea a, tableb b WHERE a.fielda(+)=b.fieldb -- what is (+)?


it is an outer-join operator (old-school).