Oracle DB Error ORA-01790 expression must have same datatype as corresponding expression

The following is the cause of this error:

A SELECT list item corresponds to a SELECT list item with a different datatype in another query of the same set expression.

Action you can take to resolve this issue: Check that all corresponding SELECT list items have the same datatypes. Use the TO_NUMBER, TO_CHAR, and TO_DATE functions to do explicit data conversions.

Tags: Database, Microsoft, SQL, Oracle, Software, DBMS

Related