Oracle DB Error ORA-00922 missing or invalid option

The following in the cause of this error:

An invalid option was specified in defining a column or stOracle DB Error ORAge clause. The valid option in specifying a column is NOT NULL to specify that the column cannot contain any NULL values. Only constraints may follow the datatype. Specifying a maximum length on a DATE or LONG datatype also causes this error.

Action you can take to resolve this issue: Correct the syntax. Remove the erroneous option or length specification from the column or stOracle DB Error ORAge specification.

Tags: Database, Education, Software

Related