ERROR at line 20:ORA-00907: missing right parenthesis

[johnpele]

HELLO USER,

WHEN I COMPLIE THIS TABLE IN ORCALE 8I I GET THE FOLLOWING ERROR MESSAGE :

ERROR at line 20:ORA-00907: missing right parenthesis.

Can anyone shed light on this problem.



create table VACANCY
(VACACNY_Id number PRIMARY KEY ,
CONSTRAINT fk_Employer_Id FOREIGN KEY (Employer_Id) REFERENCES VACANCY (Employer_Id),
CONSTRAINT fk_Application_id FOREIGN KEY (Application_id) REFERENCES Application (Application_id),
CATEGORY CHAR (40),
LOCATION CHAR (40),
CITY CHAR (40),
Enter_job_title CHAR (40),
Enter_a_Description_of_the_Job CHAR (40),
Salary CHAR (40),
per_year CHAR (40),
contact_name CHAR (40),
company_name CHAR (40),
Email CHAR (40),
coampany_address CHAR (40),
company_phone_number number(20),
fax number(20),
card_holder Char (40),
card_number number(20),
expiration date (20),
);

 

[BJCooperIT]

Try removing the comma after expiration like this:

create table VACANCY
(VACANCY_Id number PRIMARY KEY ,
.
.
.
.
expiration date (20)
);