can anyone find err...
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: 2 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