목록오라클MERGEINTO (1)

영보의 SystemOut.log

[Oracle] 오라클 MERGE INTO 사용 (MySQL: ON DUPLICATE KEY) 변환하기

MySQL 코드 (ON DUPLICATE KEY) insert into cms_main ( siteid, maintype, rollyn, rolltime, insertdate, insertuser, insertip, modifydate, modifyuser, modifyip, delyn ) values ( #{siteid},#{maintype},#{rollyn},#{rolltime}, #{insertdate},#{insertuser},#{insertip}, #{modifydate},#{modifyuser},#{modifyip},#{delyn} ) on duplicate key update rollyn=values(rollyn), rolltime=values(rolltime), modifydate=valu..
Database/Oracle 2021. 6. 5. 21:04
이전 Prev 1 Next 다음