Since UPDATE essentially is deletion + insertion, we lose the data prior to UPDATE once it is over-written. Hence, we have not allowed “UPDATE” statements.
However, this can be handled via a work-around as detailed below:
• Consider a scenario, where we have a table “UserDetails” with 2 columns – Name and Email.
• Suppose there is a need to update Email using Name as the unique identifier.
• In order to handle this, we need to create an additional table, say “UserDetails_RPA”, with same fields and do insertions in these new table.
• In order to update the Email in original table, we can create an INSERT based trigger on the new table.