ORA-00922:Missing or invalid option

[TiaTia]

I constantly am receiving this message when I run this script. Can anyone tell me what I am doing wrong?


CREATE TABLE Pathogen(s)
PathogenID VARCHAR(50),

Viral VARCHAR(50)CONSTRAINT ViralRequired NOT NULL,

Bacterial VARCHAR(50)CONSTRAINTBacterialRequired NOT NULL,

Fungal VARCHAR(50)CONSTRAINTFungalRequired NOT NULL,

CONSTRAINT PKPathogen(s) PRIMARY KEY (PathogenID))

[debasisdas]

You can't have special characters (except a few) but not the one you are trying as part of table or column name.

[amitpatel66]

Change the table name from Pathogen(s) to Pathogen then try creating a table.

Table of any name can be created by using a double quotes but its not at all advisable to do so.

If your business requirement strictly requires table name to be Pathogen(s) then try creating a table by enclosing Pathogen(s) in double quotes like "Pathogen(s)".

Also note if you create a table by using a double quote then the object name becomes case sensitive and you will have to use double quotes everytime you select/perform DML's on that particular table.

[TiaTia]

@amitpatel66
Thank you very much for your suggestion and it worked.