select a.core_txn_srl_no||a.c_dept||a.c_batch||lpad(a.c_opr_no,5,’0′)||case a.txn_dr_cr_ind when ‘借’ then ’01’ when ‘贷’ then ’02’ end TICD from GENCNORAPRDEAST.V_GRP_FULL_JYLS@EAST_AML_DB_LINK a
select a.core_txn_srl_no||a.c_dept||a.c_batch||lpad(a.c_opr_no,5,’0′)||case a.txn_dr_cr_ind when ‘借’ then ’01’ when ‘贷’ then ’02’ end TICD from GENCNORAPRDEAST.V_GRP_FULL_JYLS@EAST_AML_DB_LINK a
该资源仅限VIP专享下载