In Oracle, UPDATE
statement allows you to update multiple columns in a table. You can use the UPDATE statement to change multiple columns value of a single row, a group of rows, or all rows in a table.
To update multiple columns in existing table, use the following syntax:
Parameters:
tablename: The table name from which you want to update.
Conditions: To add specific condition. The conditions parameter is optional.
Note:
In the above example, we have updated first name and last name for the record having cellNo '2342323234' in existing table "tblCustomerLoan".