ORA-00905: missing keyword

ORA-00905: missing keyword

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

Cause:

A required keyword is missing.

Solution:

Correct the syntax.

Example:

CREATE OR REPLACE VIEW VIEW_1 
SELECT * FROM TEST3;

Output:

ORA-00905: missing keyword

Correct:

CREATE OR REPLACE VIEW VIEW_1 
AS
SELECT * FROM TEST3;

Output:

view VIEW_1 created.