UPDATE

Updating data in Oracle

Update operation is used to modify data in oracle.

Types of Update operation:

• SINGLE ROW UPDATE
• MULTIPLE ROW UPDATE
• UPDATE WITH SUBQUERY

SINGLE ROW UPDATE:

This update operation will update only one row of a table.…