クエリによるUPDATE文

Oracle12cでクエリによるUpdate文忘れがちなのでメモ

UPDATE
URIKEPF URI SET (URI.HTANKA,URI.HANKIN) = 
(
SELECT JYU.HANTAN HTANKA,
JYU.HANTAN * URI.UKENSU HANKIN
FROM
JYUTUPF JYU 
WHERE 
URI.JCDYMD = JYU.JCDYMD
AND URI.JCDNO = JYU.JCDNO
AND URI.SAKUBI >= 20161001
AND JYU.JYUKBN IN (0,1)
AND URI.HTANKA = 0
AND URI.SYUKBI >= 20161201 
AND URI.SYUKBI <=20170131
)
WHERE EXISTS
(
SELECT 1
FROM
JYUTUPF JYU 
WHERE 
URI.JCDYMD = JYU.JCDYMD
AND URI.JCDNO = JYU.JCDNO
AND URI.SAKUBI >= 20161001
AND JYU.JYUKBN IN (0,1)
AND URI.HTANKA = 0
AND URI.SYUKBI >= 20161201 
AND URI.SYUKBI <=20170131
)

UPDATE

URIKEPF URI SET (URI.HTANKA,URI.HANKIN) =

(

SELECT JYU.HANTAN HTANKA,

JYU.HANTAN * URI.UKENSU HANKIN

FROM

JYUTUPF JYU

WHERE

URI.JCDYMD = JYU.JCDYMD

AND URI.JCDNO = JYU.JCDNO

AND URI.SAKUBI >= 20161001

AND JYU.JYUKBN IN (0,1)

AND URI.HTANKA = 0

AND URI.SYUKBI >= 20161201

AND URI.SYUKBI <=20170131

)

WHERE EXISTS

(

SELECT 1