update oracle syntax code example
Example 1: update oracle
UPDATE T_NAME
SET PARAM_1=23, PARAM_2=true
WHERE PARAM_7= 'something'
Example 2: 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
}