(8.0.22)
drop table tab1;
create table tab1(col1 int);
start transaction;
insert into tab1 values(1);
savepoint sp1;
insert into tab1 values(2);
rollback to sp1;
commit;
select * from tab1;
(19c)
drop table tab1 purge;
create table tab1(col1 int);
insert into tab1 values(1);
savepoint sp1;
insert into tab1 values(2);
rollback to sp1;
commit;
select * from tab1;
(13)
drop table tab1;
create table tab1(col1 int);
start transaction;
insert into tab1 values(1);
savepoint sp1;
insert into tab1 values(2);
rollback to sp1;
commit;
select * from tab1;
(2019)
set xact_abort off
drop table tab1;
create table tab1(col1 int);
begin transaction;
insert into tab1 values(1);
save transaction sp1;
insert into tab1 values(2);
rollback transaction sp1;
commit;
select * from tab1;