oracle update with

1UPDATE T_NAME
2SET PARAM_1=23, PARAM_2=true
3WHERE PARAM_7= 'something'

1UPDATE mytable t		-- Update using WITH statement
2SET value3 = (
3    WITH comp AS (
4        SELECT id, value1
5        FROM mytable t
6        WHERE value2 > 10
7    )
8    SELECT c.value1
9    FROM comp c
10    WHERE c.id = t.id
11);

1{
2    UPDATE table-Name [[AS] correlation-Name]
3        SET column-Name = Value
4        [ , column-Name = Value} ]*
5        [WHERE clause] |
6    UPDATE table-Name
7        SET column-Name = Value
8        [ , column-Name = Value ]*
9        WHERE CURRENT OF
10}