1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| create table TABLE1 (
MATRICULE number(9) not null,
SECTION VARCHAR2(1) not null,
MODULE1 NUMBER(5) not null,
MODULE2 NUMBER(5) not null,
MODULE3 NUMBER(5) not null,
MODULE4 NUMBER(5) not null,
constraint PK primary key (MATRICULE)
)
INSERT INTO TABLE1 VALUES('1','A',10,8,6,13);
INSERT INTO TABLE1 VALUES('2','A',12,9,7,10);
INSERT INTO TABLE1 VALUES('3','A',8,10,17,10);
INSERT INTO TABLE1 VALUES('4','B',12,12,12,12);
INSERT INTO TABLE1 VALUES('6','B',10,11,9,9);
INSERT INTO TABLE1 VALUES('9','B',10,8,12,12);
INSERT INTO TABLE1 VALUES('11','B',12,4,9,10);
INSERT INTO TABLE1 VALUES('12','C',9,13,15,12);
INSERT INTO TABLE1 VALUES('10','C',12,7,4,8);
INSERT INTO TABLE1 VALUES('5','C',9,7,5,9); |
Partager