Multiple choice technology databases

____________ is the outer join operator.

  1. (+)

  2. (-)

  3. (*)

  4. +
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Oracle SQL syntax, the (+) operator is placed next to the column that may be null to indicate an outer join. For example, 'WHERE table1.id = table2.id(+)' creates a right outer join. This is Oracle's legacy outer join syntax.

Keep practicing — related questions