SQL Merge

merge.sql

MERGE INTO IMPROD.SM_TRAILER_CONTROL_LOG a
     USING (SELECT         :trailerId              AS i_trailer_id,
                           :outboundSealNumber     AS o_outbound_seal_nbr 
                     FROM DUAL
                    ) b
        ON (a.TRAILER_ID = b.I_trailer_id
            and a.outbound_seal_nbr = o_outbound_seal_nbr)
WHEN MATCHED
THEN
    UPDATE SET a.INBOUND_SEAL_NBR = b.O_outbound_seal_nbr,
               a.INBOUND_DATE = SYSDATE,
               a.INBOUND_TEMPERATURE = :inboundTemp,
               a.LOAD_TYPE_id = :loadTypeID,
               a.UPDATE_ID = :updateID,
               a.UPDATE_DATE = SYSDATE
WHEN NOT MATCHED
THEN
    INSERT     (a.trailer_id,
                a.LOAD_TYPE_ID,
                a.OUTBOUND_SEAL_NBR,
                a.OUTBOUND_DATE,
                a.update_id,
                a.update_date,
                a.create_id,
                a.create_date)
        VALUES ( :trailerID,
                :loadTypeID,
                :outboundSealNumber,
                SYSDATE,
                :updateID,
                SYSDATE,
                :createID,
                SYSDATE);