Oracle 更新多字段1

UPDATE GSM_LOT A
SET
  (
    A.LOT_FLAG,
    A.ACTION_DATE
  )
  =
  (SELECT 'O',
    CASE
      WHEN COL1 IN('0') THEN A.ACTION_DATE
      WHEN COL1 ='1' THEN DECODE(A.ACTION_DATE, NULL, SYSDATE, A.ACTION_DATE)
      ELSE SYSDATE+1
    END ACTION_DATE
  FROM DUAL
  )
WHERE A.SLIP_NO='ABC';

 

posted @ 2019-07-20 20:21  wangxinbo  阅读(176)  评论(0编辑  收藏  举报