I got ” ORA-00920: invalid relational operator” error in Oracle.
ORA-00920: invalid relational operator
Details of error are as follows.
ORA-00920 invalid relational operator
Cause: A search condition was entered with an invalid or missing relational operator.
Action: Include a valid relational operator such as =, !=, ^=, <>, >, <, >=, <=, ALL,
ANY, [NOT] BETWEEN, EXISTS, [NOT] IN, IS [NOT] NULL, or [NOT] LIKE in the condition.
invalid relational operator
This ORA-00920 errors are related with the search condition was entered with an invalid or missing relational operator.
To solve this error, Include a valid relational operator such as =, !=, ^=, <>, >, <, >=, <=, ALL,
ANY, [NOT] BETWEEN, EXISTS, [NOT] IN, IS [NOT] NULL, or [NOT] LIKE in the condition.
Don’t forget using the relational operator in the where condition.
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )