Stepwise-Lab

ORA-01790: Expression must have same data type as corresponding expression

Corresponding columns of a set operator must be in the same type family. Set operators do not convert NUMBER to text implicitly; use TO_CHAR.

On the exam

This error belongs to the topic Set operators 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