ORACLE SQL 10G Pour les Nuls & Zéro

MERGE [ hint ]
   INTO [ schema. ] { table | view } [ t_alias ]
   USING [ schema. ] { table | view | subquery }[ t_alias ]
   ON ( condition )
[ WHEN MATCHED THEN UPDATE SET column = { expr | DEFAULT }
                                              [, column = { expr | DEFAULT } ]...
[ WHERE condition ]
[ DELETE WHERE condition ]]
[ WHEN NOT MATCHED THEN INSERT [ (column [, column ]...) ]
                                        VALUES ({ expr [, expr ]... | DEFAULT })
[ WHERE condition ]];

CREATE TABLE SALAIRE
(
  ID_SAL       INTEGER      NOT NULL,
  SAL_MONTANT  NUMBER(6,2)  NOT NULL,
  SAL_PRIME    NUMBER(6,2)
)
NOLOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
NOMONITORING;

INSERT INTO SALAIRE Values(1,1300,0);
INSERT INTO SALAIRE Values(2,1500,0);
INSERT INTO SALAIRE Values(3,2300,0);
INSERT INTO SALAIRE Values(4,2870,0);
INSERT INTO SALAIRE Values(5,3455,0);
INSERT INTO SALAIRE Values(6,1499,0);
INSERT INTO SALAIRE Values(7,2100,0);

CREATE TABLE PRIME
(
  ID_PRIM   INTEGER NOT NULL,
  ID_SAL    INTEGER NOT NULL,
  SAL_PRIME NUMBER(6,2)
)
NOLOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
NOMONITORING;

INSERT INTO PRIME Values(10,1,35);
INSERT INTO PRIME Values(11,2,40);
INSERT INTO PRIME Values(12,3,100);
INSERT INTO PRIME Values(13,4,150);
INSERT INTO PRIME Values(14,5,250);

SQL> MERGE INTO SALAIRE A
USING (SELECT ID_SAL,SAL_PRIME FROM PRIME) B
ON (A.ID_SAL = B.ID_SAL)
WHEN MATCHED THEN UPDATE SET A.SAL_PRIME = B.SAL_PRIME ;