Skip to content
Advertisement

how to rollback tran when error occur in oracle

i try to solve 2 requests below but i only code for the first one,, can any one help to solve the second one

  1. Write SQL statements using cursor to update salary of all employees base on update conditionals
  2. Make sure all update records have been updated completely. The database transaction will be rolled back if any update failure).

Advertisement

Answer

Try this.

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement