Logo Pastebin.fr
Pastebin

Retrouvez, créez et partagez vos snippets en temps réel.

ouiiiiiiiiii

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;

Créé il y a 1 semaine.

Rechercher un Pastebin

Aucun paste trouvé.