Oracle UPDATE Statement
In Oracle, UPDATE statement is used to update the existing records in a table. You can update a table in 2 ways.
Traditional Update table method
Syntax:
Update Table by selecting rocords from another table
Syntax:
Parameters:
1) column1, column2, … column_n:
It specifies the columns that you want to update.
2) expression1, expression2, …expression_n:
This specifies the values to assign to the column1, column2, ?. column_n.
3) conditions:It specifies the conditions that must be fulfilled for execution of UPDATE stateme.
Oracle Update Example: (Update single column)
This example will update the supplier_name as “Kingfisher” where “supplier_id” is 2.
Oracle Update Example: (Update multiple columns)
The following example specifies how to update multiple columns in a table. In this example, two columns supplier_name and supplier_address is updated by a single statement.
Output:
1 row(s) updated. 0.06 seconds
Oracle Update Example: (By selecting records from another table)
Output:
2 row(s) updated. 0.02 seconds
Here, the customers table is updated by fetching the data from “suppliers” table.