Definition:
The Oracle UPDATE statement is how the data in a table is altered, changed, or modified. The Oracle UPDATE statement processes one or more rows in a table and then sets one or more columns to the values you specify.
UPDATE Example:
UPDATE users
SET name = 'john';
The UPDATE statement is normally used with the WHERE clause in order to specify which rows are to have their columns changed. You do this by specifying values to be matched against one or more columns in the table. Not using a WHERE clause will result in updating all of the rows table.
This example updates only the rows in the 'users' table where the 'last_name' column contains the text 'Smith':
UPDATE users
SET first_name = 'john'
WHERE last_name = 'Smith';
Related Links:
Related Code Snippets:
- UPDATE - A sample of an update statement.
