INSERT ALL
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('A01','Television 16sur9',3000,500,7,'F01')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('A02','Ecran plat',1000,345,15,'F03')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('A03','Lecteur DVD',1000,75,25,'F04')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('A04','Mini chaine de salon',1000,245,12,'F05')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('B01','Tuyau darrosage',1000,40,8,'F01')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('B02','beche',523,10,10,'F02')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('B03','arrosoir',700,12,20,'F02')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('E01','Mixeur',1000,50,23,'F02')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('E02','Machine a pain',1200,75,10,'F01')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('E03','Machine a laver le linge',70000,200,18,'F02')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('E04','Machine a laver la vaisselle',80000,300,27,'F06')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('L01','Console de jeu',750,100,11,'F01')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('L02','Raquette de tennis',400,20,9,'F04')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('L03','Lot de 4 balles de tenis',300,7,7,'F06')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('M01','Lit pour enfant',5000,150,60,'F01')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('M02','lampe',750,20,80,'F03')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('M03','canape',60000,2000,100,'F06')
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('T01','Bon en cuir',523,60,NULL,NULL)
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('T02','Bottes en cuir',400,70,NULL,NULL)
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('T03','Rideau',700,30,NULL,NULL)
INTO ART (CA, NOMA, PDSA, PRIXA, DELAI, CF)
VALUES ('T04','nappe',500,15,NULL,NULL)
SELECT 1 FROM dual;