oracle 通过查询灵活插入数据

最新推荐文章于 2024-01-09 13:00:00 发布

wl_sqfn

最新推荐文章于 2024-01-09 13:00:00 发布

阅读量1k

点赞数

本文链接：https://blog.csdn.net/wl_sqfn/article/details/107058819

版权

数据库专栏收录该内容

10 篇文章 0 订阅

订阅专栏

insert into prplclaimtoplatformfail
  (CLAIMCODE,
   REQUESTTYPE,
   CLAIMTYPE,
   COMFLAG,
   REGISTNO,
   CLAIMNO,
   POLICYNO,
   COMPENSATENO,
   RISKCODE,
   CONFIRMSEQUENCENO,
   COMCODE,
   INSUREDKINDCODE,
   LASTFAILTIME,
   LASTFAILREASON,
   INPUTTIME,
   INSERTTIMEFORHIS,
   OPERATETIMEFORHIS)
  select f.registno,
         'case4',
         CASE WHEN f.riskcode = '0360' THEN 'B' WHEN f.riskcode = '0331' THEN 'C' END,
         'Z',
         f.registno,
         null,
         f.policyno,
         f.registno,
         f.riskcode,
         b.CONFIRMSEQUENCENO,
         '04010101',
         null,
         to_date('29-05-2017 19:58:24', 'dd-mm-yyyy hh24:mi:ss'),
         null,
         to_date('29-05-2017', 'dd-mm-yyyy'),
         to_date('29-05-2017 19:58:24', 'dd-mm-yyyy hh24:mi:ss'),
         to_date('29-05-2017 19:58:24', 'dd-mm-yyyy hh24:mi:ss')
    from prplclaim a, prplclaim0531 f，prplclaimtoplatformmain b
   where a.caseno is not null
     and a.registno like 'R04%'
     AND A.CASETYPE = '2'
     AND A.SUMPAID <> 0
     and f.claimno = a.claimno
     and b.registno = f.registno
   order by a.endcasedate;