Oracle Database Error Code ORA-1796 Description :
this operator cannot be used with lists
Error Cause:
A relational operator is not allowed in this context. When comparing lists, use only an operator that tests for equivalence, such as =, !=, or IN.
How to Solve :
Rephrase the query so that it only compares lists for equivalence. For example, the following clause is invalid:WHERE (A,B) > ((C,D), (E,F)) It may be necessary to compare individual columns separately. For example, to see if A and B are respectively greater than C and D, use WHERE A>B AND C>D instead of WHERE (A,B)>(C,D).
Search Oracle Error Codes and Descriptions:
Be The First To Comment
Similar Errors
Please Leave Your Comments Below