Stepwise-Lab

ORA-01789: Query block has incorrect number of result columns

All queries combined with UNION, INTERSECT or MINUS must select the same number of columns. Pad with NULL or a literal where a column is missing.

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