ORA-01790
expression must have same datatype as corresponding expression
Cause
A SELECT list item corresponds to a SELECT list item with a different datatype in another query of the same set expression.
Action
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.
ORA-01790
expression must have same datatype as corresponding expression
Cause
A SELECT list item corresponds to a SELECT list item with a different datatype in another query of the same set expression.
Action
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.
ORA-01790
expression must have same datatype as corresponding expression
Cause
A SELECT list item corresponds to a SELECT list item with a different datatype in another query of the same set expression.
Action
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.