Oracle database error code ORA-01790 – expression must have same datatype as corresponding expression

Oracle Database Error Code ORA-1790 Description :
expression must have same datatype as corresponding expression
Error Cause:
A SELECT list item corresponds to a SELECT list item with a different datatype in another query of the same set expression.

How to Solve :
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.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»