Oracle > Update – Select
update (
SELECT * FROM temp_dim tableIn,
temp_dates dates1,
temp_dates dates2
WHERE dates1.ID = tableIn.VALID_FROM
AND dates2.ID = tableIn.valid_to
AND SYSDATE BETWEEN dates1.FULL_DATE AND dates2.full_date
)
set valid_flag = 1