Stepwise-Lab

ORA-25556: (+) with an OR operand that lacks it

This database allows OR in an outer join condition only when every operand marks the optional table with (+). Write the join in ANSI syntax with the whole condition in ON. The 19c documentation, and the 1Z0-071 exam, give ORA-01719 for any (+) inside an OR.

On the exam

This error belongs to the topic Joins of exam 1Z0-071.

In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.

All Oracle errors