Illustrating Rollback within Live SQL

View All Scripts Login to Run Script

Script Name Illustrating Rollback within Live SQL
Description When you press [Run], all the statements are auto committed so the only way to illustrate rollback is within a transaction. The first 5 statements were run as one transaction and then number 6 and 7 were each run separately. That is why the rollback in #4 is respected while the one in #8 is not. Please note that when you run this, the second rollback will be respected because we run a script as one transaction. To replicate, you need to run 1-5 at once and then the rest, one statement at a time.
Area SQL General / Data Manipulation
Contributor Oracle
Created Thursday July 19, 2018

Statement 1

create table temp (col1 varchar2(30))

Table created.

Statement 2

insert into temp values ('now there is data')

1 row(s) inserted.

Statement 3

The data is there.

select * from temp


COL1
now there is data

COL1
now there is data

Statement 7

The data is there (as expected).

select * from temp


COL1
standalone insert

COL1
standalone insert

COL1
standalone insert

Additional Information