`

oracle的merge

 
阅读更多
merge into TBWKRECMAINTAINFUNDINFO t
   using (select 3 as fid, 456 as OPTYPENUM, 2 as recyear, 2 recnum from dual) t1
   on(t.fid = t1.fid)
    when not matched then
    insert(FID,OPTYPENUM,recyear,recnum) values(3, 3, 3, 3);

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics