1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
|
CREATE TABLE FOURNISSEUR
( CODE INTEGER,
NOM VARCHAR(30)
);
COMMIT;
INSERT INTO FOURNISSEUR VALUES (1,'TOTO');
INSERT INTO FOURNISSEUR VALUES(2,'TATA');
INSERT INTO FOURNISSEUR VALUES(3,'TUTU');
CREATE TABLE ACHAT
( FOURNISSEUR INTEGER,
MONTANT_NET NUMERIC(15,2)
);
COMMIT;
INSERT INTO ACHAT VALUES(1,100);
INSERT INTO ACHAT VALUES(2,200);
CREATE TABLE REGLEMENT
( FOURNISSEUR INTEGER,
MONTANT_VERSE NUMERIC(15,2)
);
COMMIT;
INSERT INTO REGLEMENT VALUES(1,10);
INSERT INTO REGLEMENT VALUES(1,10);
INSERT INTO REGLEMENT VALUES(1,10);
INSERT INTO REGLEMENT VALUES(1,10);
INSERT INTO REGLEMENT VALUES(1,10);
INSERT INTO REGLEMENT VALUES(1,10);
INSERT INTO REGLEMENT VALUES(2,150); |
Partager