ORA-00908: missing NULL keyword

ORA-00908: missing NULL keyword

Oracle PL/SQL error message: ORA-00908: missing NULL keyword.

Cause:

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.

Solution:

Check the syntax and correct.

Example:

SELECT s.first_name, s.LAST_NAME
FROM students s
WHERE s.ADDRESS IS NOT;

Output:

ORA-00908: missing NULL keyword

Correct:

SELECT s.first_name, s.LAST_NAME
FROM students s
WHERE s.ADDRESS IS NOT NULL;