inserts_RO.sql 1.63 KB
Newer Older
Gaetan Carabetta's avatar
Gaetan Carabetta committed
1

Osvaldo Valdivia Salas's avatar
Osvaldo Valdivia Salas committed
2
INSERT INTO espece (classeEspece,espece)
Gaetan Carabetta's avatar
Gaetan Carabetta committed
3
VALUES ('mammifer','hamster');
Osvaldo Valdivia Salas's avatar
Osvaldo Valdivia Salas committed
4 5 6
/

INSERT INTO espece (classeEspece,espece)
Gaetan Carabetta's avatar
Gaetan Carabetta committed
7
VALUES ('mammifer','chien');
Osvaldo Valdivia Salas's avatar
Osvaldo Valdivia Salas committed
8 9 10
/

INSERT INTO espece (classeEspece,espece)
Gaetan Carabetta's avatar
Gaetan Carabetta committed
11
VALUES ('mammifer','chat');
Osvaldo Valdivia Salas's avatar
Osvaldo Valdivia Salas committed
12 13 14
/

INSERT INTO client (id_client,nom,prenom,dn,adresse,numeros)
Gaetan Carabetta's avatar
Gaetan Carabetta committed
15
VALUES (1,'VALDIVIA','Osvaldo',to_date('27-12-1998','DD-MM-YYYY'),'6 bis rue Winston Churchill',listNumeros('1029384756','5534034564'));
Osvaldo Valdivia Salas's avatar
Osvaldo Valdivia Salas committed
16 17 18 19
/


INSERT INTO client (id_client,nom,prenom,dn,adresse,numeros)
Gaetan Carabetta's avatar
Gaetan Carabetta committed
20
VALUES (2,'CARABETTA','Gaetan',to_date('10-06-1996','DD-MM-YYYY'),'16 rue Gambeta',listNumeros('5647384950','1738493728','5748394782'));
Osvaldo Valdivia Salas's avatar
Osvaldo Valdivia Salas committed
21 22 23 24
/


INSERT INTO client (id_client,nom,prenom,dn,adresse,numeros)
Gaetan Carabetta's avatar
Gaetan Carabetta committed
25
VALUES (3,'ALANIS','Oswaldo',to_date('14-05-1998','DD-MM-YYYY'),'52 av. Compiegne ',listNumeros('5647384950'));
Osvaldo Valdivia Salas's avatar
Osvaldo Valdivia Salas committed
26 27
/

Gaetan Carabetta's avatar
Gaetan Carabetta committed
28 29
INSERT INTO animal(id_animal,id_client,espece,nom,poid,TAILLE,dn,traitements)
VALUES (1,1,'chien','Diego',4050,300,to_date('15-04-2005','DD-MM-YYYY'),listTraitements(traitement(1,to_date('09-10-2018','DD-MM-YYYY'),5,2,'Pierre','Hueys'),traitement(2,to_date('11-12-2018','DD-MM-YYYY'),5,2,'Pierre','Orphex')));
30 31 32 33 34 35 36


INSERT INTO animal(id_animal,id_client,espece,nom,poid,TAILLE,dn,traitements)
VALUES (2,2,'chat','Doris',2100,200,to_date('15-02-2008','DD-MM-YYYY'),listTraitements(traitement(3,to_date('01-10-2019','DD-MM-YYYY'),4,1,'Jean','Hueys'),traitement(4,to_date('02-12-2019','DD-MM-YYYY'),6,3,'Pierre','Orphex')));


INSERT INTO animal(id_animal,id_client,espece,nom,poid,TAILLE,dn,traitements)
Gaetan Carabetta's avatar
Gaetan Carabetta committed
37
VALUES (3,3,'hamster','Pochoclo',100,10,to_date('10-10-2018','DD-MM-YYYY'),listTraitements(traitement(5,to_date('15-01-2019','DD-MM-YYYY'),4,1,'Valentin','Marphel')));