update table pl 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];