Right parenthesis error

[Ragavan R]

I have an error showing 'right parenthesis error', so someone can help me?

create table employee11(
empname varchar2(15),
empid number primary key,
address char(30),
dept_code number foreign key,
salary number not null,
gender varchar2(2) check m or f,
dob date,
ph_no number unique key
);

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

[rski]

Check the create table syntax and fix your query

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7002.htm

[mani vannan]

create table employee11(
empname varchar2(15),
empid number primary key,
address char(30),
dept_code number references employee11(empi d),
salary number not null,
gender varchar2(2) check(gender in ('m','f')),
dob date,
ph_no number unique)


please try this above table structure ragavan.......