1.     id      number NOT NULL PRIMARY KEY,
    2.     name    varchar2(50)    NOT NULL,
    3.     value   number NOT NULL,
    4.     gmt_create  date NOT NULL DEFAULT sysdate,
    5.     gmt_modified    date NOT NULL DEFAULT sysdate 
    6. );
    8. obclient> INSERT INTO t_merge(id,name,value) values(1,'CN',1),(2,'US',2);
    9. Query OK, 2 rows affected (0.01 sec)
    10. obclient> MERGE INTO t_merge t2
    11.  USING (SELECT id,name,value,gmt_create FROM t_insert ) t1
    12.  ON (t2.id=t1.id)
    13.  WHEN MATCHED THEN
    14.      UPDATE SET t2.name=t1.name, t2.value=t1.value, t2.gmt_modified=sysdate
    15.  WHEN NOT MATCHED THEN
    16.      INSERT (t2.id,t2.name,t2.value) values(t1.id, t1.name, t1.value)
    17.  ;
    18. Query OK, 3 rows affected (0.01 sec)
    19. obclient> select * from t_merge;  
    20. +----+------+-------+---------------------+---------------------+
    21. | ID | NAME | VALUE | GMT_CREATE          | GMT_MODIFIED        |
    22. +----+------+-------+---------------------+---------------------+
    23. |  1 | CN   | 10001 | 2020-04-02 17:51:59 | 2020-04-02 17:52:52 |
    24. |  2 | US   | 10002 | 2020-04-02 17:51:59 | 2020-04-02 17:52:52 |
    25. |  3 | EN   | 10003 | 2020-04-02 17:52:52 | 2020-04-02 17:52:52 |
    26. +----+------+-------+---------------------+---------------------+
    27. 3 rows in set (0.01 sec)