CREATE TABLE  empMercure (NUMEMP NUMBER PRIMARY KEY,
NOMEMP VARCHAR2(30), PRENOMEMP VARCHAR2(30), 
EMPLOI VARCHAR2(30),
SALAIRE NUMBER(8,2));


insert into empMercure   values (1,'Bidon','Dindon','PROGRAMMEUER',21000);
insert into empMercure  values (2,'Lepine','David','PROGRAMMEUER',45000);
insert into empMercure   values (3,'Valente','Olivier','PROGRAMMEUER',45000);
insert into empMercure   values (4,'Patoche','Alain','PROGRAMMEUER',45000);
insert into empMercure   values (5,'Proulx','William','PROGRAMMEUER',45000);
insert into empMercure  values (6,'Paquette','Nathalie','FINANCES',35000);
insert into empMercure  values (7,'Poitras','Clara','FINANCES',35000);
insert into empMercure   values (9,'Lechat','Remi','FINANCES',35000);
commit;