Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --------------------------------------------------------
- -- CREATE Table ETUDIANT
- --------------------------------------------------------
- DROP TABLE ETUDIANT;
- CREATE TABLE ETUDIANT (
- NUMETU VARCHAR2(10 BYTE) CONSTRAINT ETUDIANT_PK PRIMARY KEY,
- NOMETU VARCHAR2(20 BYTE) NOT NULL,
- MOYENNE NUMBER(5,2) NOT NULL,
- GROUPE VARCHAR2(5 BYTE) NOT NULL
- ) ;
- --------------------------------------------------------
- -- INSERT into Table ETUDIANT
- --------------------------------------------------------
- INSERT into ETUDIANT (NUMETU,NOMETU,MOYENNE,GROUPE) values ('p2807','EVA','12','G2S2');
- INSERT into ETUDIANT (NUMETU,NOMETU,MOYENNE,GROUPE) values ('p0007','BONDE','7,5','G6S2');
- INSERT into ETUDIANT (NUMETU,NOMETU,MOYENNE,GROUPE) values ('p2649','BRAD','15,5','G4S2');
- INSERT into ETUDIANT (NUMETU,NOMETU,MOYENNE,GROUPE) values ('p7723','PENELOPE','14,5','G4S2');
- INSERT into ETUDIANT (NUMETU,NOMETU,MOYENNE,GROUPE) values ('p1842','CINDY','12,5','G3S2');
- INSERT into ETUDIANT (NUMETU,NOMETU,MOYENNE,GROUPE) values ('p2333','BOB','9','G2S2');
- INSERT into ETUDIANT (NUMETU,NOMETU,MOYENNE,GROUPE) values ('p1025','SALMA','15,5','G1S2');
- INSERT into ETUDIANT (NUMETU,NOMETU,MOYENNE,GROUPE) values ('p1009','GEORGE','17,5','G6S2');
- INSERT into ETUDIANT (NUMETU,NOMETU,MOYENNE,GROUPE) values ('p2694','MATT','14,5','G1S2');
- INSERT into ETUDIANT (NUMETU,NOMETU,MOYENNE,GROUPE) values ('p3801','HIRSCHER','18,5','G3S2');
- INSERT into ETUDIANT (NUMETU,NOMETU,MOYENNE,GROUPE) values ('p9999','LENEUF','9,9','G4S2');
- COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement