参数为:${act_cd},${seqno},${act_cd},${seqno}
参数类型为:VARCHAR,VARCHAR,VARCHAR
我是否需要重复${act_cd}
和${seqno}
多次,或者是否有快捷方式?
因为我有50多个带有重复值的参数。
and xxxx__cd = prots_cd
and xxxx_eff_date_to is null
and xxxx_gt_type = 'R'
and xxxx_act_cd = ?
and xxxx_seqno = ?
and xxxx_p_method = yyyy_pmethod
and yyyy_act_cd = ?
and yyyy_act_seqno = ?
and yyyy_inout_ind = 'I'
and yyyy_pay_method = 'SD'