oracel merge into ,insert into

1. merge into

mapper 接口：
void insertGenerateData5521(List list);
xml-sql:
<update id=“insertGenerateData5521” parameterType=“java.util.List”»
MERGE INTO tb ci 5521 a using (
¿foreach collection-“list” index-“index” item-“item” open-“” close-“” separ
select
#{item- JLXH,jdbCT yPe=DECIMAL) AS JLXH,f{itemZSDM, jdbCType=VARCHARI AS ZSD4,f(item- ZQDM, jdbCT yPe=VARCHARJ AS ZRDM,#{ite- ZQJC, jabCI ype=VARCHAR) AS ZQJC.
decode (# (item. SSDD, jdbcIype=VARCHAR),
深圳•口，‘上海”1，•香港，,2) 25 5SDD，
#tite_NELX,jdbCIyPe=VA RCHAR} AS WELXftite- JSBZ, I abCIyPE=DECIMAL) AS ISRZ
#(item.CZIX, jdbcType-VARCHAR) AS CZIX,
(item LIGQS, jabcIype-DECIMAL] AS LIGQ5,
(item. QSSJ, jdbcIype=DECIMAL) AS QSSJ, ‡(item. XGTJ, jdbcType-VARCHAR) AS XGIJ,
(item. CZFW, jdbcIype=VARCHAR) AS CZFW,
(item YWMC, jdbcIype=VARCHAR} AS YWMC,
#(item.RIQI, jdbcType=DATE) AS RIQI,
(item.IZYZ, jdbeType=DECIMAL} AS IZYZ,
‡(item_WHLB, jdbcT ype=VARCHARI AS WHLB, #(item OB_ROLE_ ID, jdbcIype=DECIMAL\ AS OB_ROLE_ID,
(item. DRBZ, jdbcIype-VARCHAR) AS DRBZ,
(item MARKETMARK, jdbcIype-VARCHAR] AS MARKEIMARK,

E1item OE_ ROLE NANE S CbCI VPe VARCHAR AS OP_ROLE_ NANE.
ftitem-EZ, jabCI YPe-VARCHARI AS EZ
from dual
I
) b
on to
char (a_RIQI, vyyy-mm-dd’) = to_char (b.RIQI, ‘yyyy-man-dd’) and
a_OB_ROLE_ID = b_OB ROLE_ID and
a.DRBZ = b. DRBZ and
a_CZIX = b. CZLX and
a_ZSDM = b_ZSDM and
a_ZQDM =b_ZQDM
)
when matched then update set
a. SSDD = b. SSDD,
E-WELX - b-WELX,
a.JsB2 = b.JsBz,
a_LIGQS = b. LIGQS,
a.QsSJ = b-QSSJ,
a.XGIJ = b.XGIJ,
a. CZEW = b. CZFW,
a. YWMC = b. YWMC,
a.TZYZ = b.IZYZ,
a .MARKETMARK = b. MARKETMARK,
a.ob role name = b.ob
role name,
a_BZ = b.BZ
when not matched then insert
(E-JLXE, =-ZSDM. =-ZQDM, a- ZQJC,a-SSDD, E-WELx, e- JSBZ,a-C2Ix, a-LIGQS.a-QsSJ, a-xGTJ,a-CzET)
values
(SEQLCI_ID-NEXIVAL,D-2SDM, 5-29D4,5-29JC,b-SSDD.b-MELx,5-JSB2,b-C2Ix,D-LIGQS,b-QSSJ,b.)

2.insert into

1
mapper 接口：
insertDividendChange5506(@Param(“table5506List”) List<PublicAlls table!
2.xml-sql:
<insert id=“insertDividendChange5506” parameterType=“java.util.List"y
T
insert into tb ci 5506
JLXH, ZSDM, ZSJC, ZQDM, ZQJC, SSDD, WFIX, JSEZ, CZLX, LIGOS, aSsJ,
XGIJ, CZEW, ZSQC, YWMG, TZSZ, RIQI, IZYZ, WHLB, ZRSP, DRBZ, MARKETMARK, OB_ ROLE_ID,
createTime
select seg ci id nextval as JLKH
A
from (
<foreach collection=“table5506Iist” item-”'publicA11”
index-“index” separator="union all"s
select #{publicAll.ZSDM, jdbcType=VARCHARI,
#fpublicAll.ZSJC, jdbcType=VARCHAR},
#(publicAll.ZQDM, jdbcType=VARCHAR),
#{publicAll.ZQJC, jdbcType-VARCHARI,
#{publicAll. SSDD, jdbcIype=VARCHAR],
‡(publicAll.WFLX , jdbcType-VARCHAR],
#(publicAll.JSBZ, jdbcIvpe=DECIMAL),
#(publicAll_CZIX, jdbcType=VARCHAR),
#(publicAll.LIGQS, jdbcIype-DECIMAL},
#(publicAll.QSSJ, jdbcType-DECIMAL),
#{publicAll.XGIJ , jdbcType-VARCHAR),
#(publicAll. CZFW , jdbeType=VARCHAR],
#(publicAll_ZSQG, jdbcType-VARCHARI,
#{publicAll. YWMC , jabcType=VARCHAR},
#(pub11cA11 IZSZ ,JdbCI YPE-DECIMAL},
#{publicAll. RIQI, jdbolype=DAIE },
#{publicAll.IZIZ, jdbcType-DECIMAL],
#{publicAll.WHLB , jdbcType-VARCHAR},
#{publicAll_ZRSP, jdbcType-DECIMAL},
#(publicAll.DRBZ, jdbcType-VARCHAR),
#(publicAll.MARKETMARK, jabcType=VARCHARI,
#(publicAl1.0B_ROLE_ID,
jdbcType-DECIMAL],
#{publicAll.createTime, jdbaType=DATE }
from dual
</foreachs
) A
</ifs
kif test="table5506List. size ()==0
select sysdate from dual </ifs