Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- TP --
- INSERT INTO PILOTE VALUES (8, 'TRULLI', 'Jarno','Italie');
- INSERT INTO ECURIE VALUES (6, 'Lotus');
- INSERT INTO APPARTENIR VALUES (8, 6, 2010);
- INSERT INTO CIRCUIT VALUES (4, 'Albert-Park', 'Australie');
- INSERT INTO COURSE VALUES (13, 2010, 'sec',4);
- INSERT INTO EFFECTUER VALUES (13, 8, 24);
- update CIRCUIT_DISTANCE
- set distance = 5303
- where nuCi = 4;
- delete from CIRCUIT_DISTANCE
- where nuCi = 4;
- --q9--
- drop table circuit_distance;
- --q10--
- desc course;
- --Q11--
- select table_name from user_tables;
- /* q13 La course 14 n'existe pas */
- INSERT INTO effectuer VALUES (14, 7, 2);
- -- q14 --
- alter table pilote
- modify nuPilote number(6);
- --q14 une colonne doit être vide pour modifier sa longueur max. ou sa précision --
- alter table pilote
- modify nuPilote number(5);
- --q15--
- alter table circuit
- modify paysCi CONSTRAINT nn_circuit_pays not null;
- alter table appartenir
- modify annee default 2010;
- alter table Appartenir
- modify annee constraint ck_ecurie_annee check(annee > 0);
- --q16--
- select constraint_name
- from user_constraints
- group by CONSTRAINT_NAME;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement