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;
原创文章，作者：Maggie-Hunter，如若转载，请注明出处：https://blog.ytso.com/tech/database/4971.html