1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| CREATE OR REPLACE TYPE Tmat as OBJECT(
codeM NUMBER ,
nomM VARCHAR2(30) ,
coefM NUMBER
);
/
CREATE OR REPLACE TYPE Matiere_tbl AS TABLE OF Tmat;
/
DROP TABLE Matiere CASCADE CONSTRAINTS;
/
CREATE TABLE Matiere OF Tmat (PRIMARY KEY(codeM));
/
CREATE OR REPLACE TYPE Tens AS OBJECT(
codeEns NUMBER ,
nomEns VARCHAR2(30) ,
prenomsEns Tprenoms ,
adresse TypAdresse ,
salaire TypSalaire ,
telephone TypTelephone ,
ens_mat REF Tmat CONSTRAINT fk_ens_mat REFERENCES Matiere(codeM)
); |
Partager