oracle update with select 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: oracle SQL update
UPDATE table
SET column1 = expression1,
column2 = expression2,
...
column_n = expression_n
[WHERE conditions];