How to solve Oracle Database Error 1796 (ora-01796)
Oracle Error Code
ora-01796
Description
this operator cannot be used with lists
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.
Action
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).
Be The First To Comment
Related Post
Please Leave Your Comments Below