Database Error Messages

ORA-01789

query block has incorrect number of result columns

Cause

All of the queries participating in a set expression do not contain the same number of SELECT list columns.


Action

Check that all the queries in the set expression have the same number of SELECT list columns.