Oracle 26ai

ORA-00908

Cause

For the IS or IS NOT logical operator, the keywords NULL, TRUE, or FALSE were not found, nor were other predicates like JSON, NAN, or EMPTY. For example, the following statement generates this message: SELECT * FROM EMP WHERE DEPTNO IS NOT;


Action

Use a predicate after an IS or IS NOT logical operator.