what is for update in oracle code example
Example 1: oracle update with
UPDATE mytable t -- Update using WITH statement
SET value3 = (
WITH comp AS (
SELECT id, value1
FROM mytable t
WHERE value2 > 10
)
SELECT c.value1
FROM comp c
WHERE c.id = t.id
);
Example 2: update oracle
UPDATE T_NAME
SET PARAM_1=23, PARAM_2=true
WHERE PARAM_7= 'something'