update statement oracle sql code example

Example 1: update oracle

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

Example 2: pls sql update

UPDATE table
SET column1 = expression1,
    column2 = expression2,
    ...
    column_n = expression_n
[WHERE conditions];

Example 3: update table syntax in oracle

{
    UPDATE table-Name [[AS] correlation-Name]
        SET column-Name = Value
        [ , column-Name = Value} ]*
        [WHERE clause] |
    UPDATE table-Name
        SET column-Name = Value
        [ , column-Name = Value ]*
        WHERE CURRENT OF
}