Oracle DB Error ORA-00908 missing NULL keyword

The following in the cause of this error:

Either of the following: In a CREATE TABLE or ALTER TABLE statement, NOT was entered to specify that no null values are allowed in that column, but the keyword NULL was omitted. In the IS [NOT] NULL logical operator, the keyword NULL was not found. For example, the following statement generates this message:

SELECT * FROM EMP WHERE DEPTNO IS NOT;

Action you can take to resolve this issue: Correct the syntax.

Tags: Database, Education, Software

Related