DROP TABLE Student CASCADE CONSTRAINTS;
CREATE TABLE Student(
matr CHAR(9)
CONSTRAINT student_matr_pk PRIMARY KEY,
nume VARCHAR2(20)
CONSTRAINT student_nume_NN NOT NULL,
prenume VARCHAR2(20),
DDN DATE,
sex CHAR CHECK (sex in('M','F'));
INSERT INTO Student(matr,nume,prenume,DDN,sex) VALUES ('437890245',
'Teodorescu', 'Anca', TO_DATE('10-20-1981', 'MM-DD-YYYY'),'F');
COMMIT;