nbsp;            13
             6 李六                         14

    sql@kokooa>select * from test001;

            ID NAME            TEL ADDRESS
    ---------- -------- ---------- --------------------
             1 aaa             234
             2 bbb             234
             3 ccc             234
             4 ddd
             5 王五            111 333
             6 张三             22
             7 李四             20

    merge into student s
    using
    (
       select id,name,tel from test001)x
       on
         (s.s_id=x.id)
       when matched
       then update set s_name=x.name
       when not matched
       then insert
        (s_id,s_name,s_age)
       values
        (x.id,x.name,x.tel);
    commit;

    最终结果：
    sql@kokooa>select * from student;

          S_ID S_NAME                    S_AGE
    ---------- -------------------- ----------
             1 aaa                          15
             2 bbb    &