Aug 01, 2020 8:20 am
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)
);