text: -- @testpoint: default参数,用对应字段的缺省值填充该字段，如果没有缺省值，则为NULL，进行merge into操作
  --step1: 创建目标表和源表并插入数据; expect: 成功
  drop table if exists t_mergeinto_33_01;
  drop table if exists t_mergeinto_33_02;
  create table t_mergeinto_33_01(product_id integer default 0001,product_name varchar2(60),
  category varchar2(60));
  insert into t_mergeinto_33_01 values (1501, 'vivitar 35mm', 'electrncs');
  insert into t_mergeinto_33_01 values (1502, 'olympus is50', 'electrncs');
  insert into t_mergeinto_33_01 values (1600, 'play gym', 'toys');
  insert into t_mergeinto_33_01 values (1601, 'lamaze', 'toys');
  insert into t_mergeinto_33_01 values (1666, 'harry potter', 'dvd');
  create table t_mergeinto_33_02(product_id integer,product_name varchar2(60),
  category varchar2(60));
  insert into t_mergeinto_33_02 values (1502, 'olympus camera', 'electrncs');
  insert into t_mergeinto_33_02 values (1601, 'lamaze', 'toys');
  insert into t_mergeinto_33_02 values (1666, 'harry potter', 'toys');
  insert into t_mergeinto_33_02 values (1700, 'wait interface', 'books');
  --step2: 进行merge into 操作 ;expect: 成功
  merge into t_mergeinto_33_01 t1  using t_mergeinto_33_02 t2
  on (t1.product_name = t2.product_name)
  when not matched then
   insert  (product_name,category) values ( t2.product_name,t2.category)
  when matched then
     update set t1.product_id = t2.product_id, t1.category = t2.category;
  --step3: 查询更新后的结果 ;expect: 成功
  select * from t_mergeinto_33_01 order by product_id;
  --step4: 清理环境删除表  ;expect: 成功
  drop table t_mergeinto_33_01;
  drop table t_mergeinto_33_02;