Oracle一次更新(UpData)多列通过Select获取到的值

1. 第一种MERGE INTO方法

MERGE INTO SAFERUNWMS.WCSSTOCKLOC WSL
  USING(
          SELECT
            WSP.LOCNO,
            WSP.MATERCODE,
            WSP.PALLETNO,
            WSP.BATNO
          FROM SAFERUNWMS.WCSSTOCKPORT WSP
          WHERE WSP.LOCNO = N_STOCKLOC
       )SOURCE
ON(WSL.LOCNO = SOURCE.LOCNO)
WHEN MATCHED THEN
  UPDATE SET
    WSL.MATERCODE = SOURCE.MATERCODE,
    WSL.PALLETNO = SOURCE.PALLETNO,
    WSL.BATNO = SOURCE.BATNO,
    WSL.UPDATE_TIME = SYSDATE();

2. 第二种Updata+Select方法

UPDATE SAFERUNWMS.WCSSTOCKLOC WSL		
SET (
      WSL.MATERCODE,
      WSL.PALLETNO,
      WSL.BATNO,
      WSL.UPDATE_TIME
    )
= (
    SELECT
          WSP.MATERCODE,
          WSP.PALLETNO,
          SYSDATE()
    FROM SAFERUNWMS.WCSSTOCKPORT WSP
    WHERE WSP.LOCNO = N_STOCKLOC 
  )
WHERE WSL.LOCNO = N_STOCKLOC;