Oracle rollback demonstration

SQLgt; locktablestateinexclusivemode; Table (s) Locked. SQLgt; insertintostate (state_cd, state_name) values (

SQLgt; lock table state in exclusive mode; Table (s) Locked. SQLgt; insert into state (state_cd, state_name) values (

Oracle rollback demonstration

[Date:] Source: Linux community Author: huzia [Font:]

After the data is inserted, you can see the data,

However, after the rollback, the system will return to the status before the insertion,

The data inserted before rollback is canceled.

After the rollback command is executed,

The lock applied to the state table is automatically unlocked.

,