Forum

can anyone find err...
 
Notifications
Clear all

can anyone find error in this code and tell me the error to rectify it?


Info User
Posts: 47
 Info User
Topic starter
(@Info User)
Joined: 1 year ago

Query is given below.

create table employeees(
Firstname varchar2(15) Not null,
Midname varchar2(5),
Lastname varchar2(15) Not null,
SSNnumber char(9),
birthday date,
address varchar2(50),
Sex char(1),
salary int default 800,
superSSN char(9),
depnum numeric(5),
primary key(SSNnumber),
check (Sex == 'M' OR 'F' OR 'm' OR 'f'),
foreign key(depnum) references departments(depnum)
);

Share: