insert into 配合 select批量插入详解数据库

insert into t_s_fun_custom 
  (c_iden, 
   c_fun_code, 
   c_fun_name, 
   c_fun_code_p, 
   n_fun_type, 
   n_order, 
   n_default, 
   c_ico_file, 
   c_plan_code) 
  select SEQU_S_FUN_CUSTOM.NEXTVAL, 
         c_fun_code, 
         c_fun_name, 
         c_fun_code_p, 
         n_fun_type, 
         n_order, 
         n_default + 2 as n_default, 
         c_ico_file, 
         replace(c_plan_code, ' ', '') || 'DefaultOldBiz' as c_plan_code 
    from t_s_fun_custom 
   where c_dv_app_cls = 'FUN_BIZ' 
     and c_plan_code = ' ' 
     and n_default = 0;