pl/sql update子查询

最新推荐文章于 2024-07-03 09:00:00 发布

lee576

最新推荐文章于 2024-07-03 09:00:00 发布

阅读量3k

点赞数

分类专栏： Oracle 文章标签： date 2010

本文链接：https://blog.csdn.net/lee576/article/details/5840495

版权

Oracle 专栏收录该内容

33 篇文章 1 订阅

订阅专栏

update MT_PL_ZSBATCHDISPLAY_VER x
   set x.lastmonthsilkquantity = (select lastmonthsilkquantity
                                    from MT_PL_ZSBATCHDISPLAY_VER y
                                   where y.pb_pd_materialid =
                                         x.pb_pd_materialid
                                     and y.leafblendno = x.leafblendno
                                     and y.mt_pl_mainplanbatchrecord_id =
                                         '3edfc47a-0cc6-4beb-84f1-50b9d4580f62')
where x.mt_pl_mainplanbatchrecord_id =
       '9df6ca40-edae-4071-85b0-7d924edcf9f0'

update MT_PL_ZSBATCHDISPLAY_VER x
   set x.lastmonthbatchnunber = (select lastmonthbatchnunber
                                   from MT_PL_ZSBATCHDISPLAY_VER y
                                  where y.pb_pd_materialid =
                                        x.pb_pd_materialid
                                    and y.leafblendno = x.leafblendno
                                    and y.mt_pl_mainplanbatchrecord_id =
                                        '3edfc47a-0cc6-4beb-84f1-50b9d4580f62')
where x.mt_pl_mainplanbatchrecord_id =
       '9df6ca40-edae-4071-85b0-7d924edcf9f0'

update MT_PL_LEAFBLENDBATCH_DEL x

set x.blendingstatus = 0

where (pb_pd_materialid, productbatchno, leafblendno) in

(select pb_pd_materialid, productbatchno, leafblendno

from MT_PL_ZSBATCHDISPLAYDETIAL_VER t1

where t1.mt_pl_mainplanbatchrecord_id in

(select t.mt_pl_mainplanbatchrecord_id

from MT_PL_MAINPLANBATCHRECORD t

where t.planmonth = to_date('2010-08-01', 'yyyy-MM-dd')))