Forum

can anyone find err...
 
Share:
Notifications
Clear all

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


Posts: 47
Guest
Topic starter
(@Info User)
Eminent Member
Joined: 4 years 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)
);

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: