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

Last Post

Posts: 47

Info User

Guest

Topic starter

Aug 01, 2020 8:20 am

(@Info User)

Eminent Member

Joined: 3 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)
);

Topic Tags

Whatiserror givensqlquery