---

Oracle Update Statement

In Oracle, UPDATE statement allows you to update the existing column in a table. You can use the UPDATE statement to change column values of a single row, a group of rows, or all rows in a table.

Oracle UPDATE TABLE Syntax

To update the existing record in 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.

Oracle UPDATE TABLE examples

The following Oracle statement to updating first name and last name for record having cellNo '2342323234' in tblCustomerLoan table:

Note:

In the above example, we have updated first name for the record having cellNo '2342323234' in existing table "tblCustomerLoan".

---

---