Showing posts with label ora-00908 help. Show all posts
Showing posts with label ora-00908 help. Show all posts

Tuesday, October 18, 2022

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

Featured Post

Ora-00921 Unexpected end of SQL Command

 ORA-00921 unexpected end of SQL command     Oracle Database Error Code Messages ORA-00921 About Help Description; Unexpected end of SQL com...

Search This Blog