Ora-00908 missing NULL keyword

 ORA-00908 missing NULL keyword

    Oracle Database Error Code Messages ORA-00908 About Help Description;

Missing NULL keyword.

    Cause for Error and Problem;

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; 

The keyword NULL must follow the keywords IS NOT.

    How to Solve;ORA-00908 missing NULL keyword?

    Action for Solve and Fix Ora-00908;

Correct the syntax.

Next Posts Ora-28552;

Ora-28552 pass-through SQL: call flow error