Oracle Update

Oracle Update statement

How to use the UPDATE statement to modify the value of a column in a table.

Oracle Update syntax

UPDATE table_name
SET column_name = value [, column_name = value]...
[ WHERE condition ];

Update example

UPDATE CUSTOMERS
SET 
  NAME = 'Customer_Abc',
  ADDRESS = 'Address 1Abc'
WHERE ID=1 
AND NAME='Customer_A';