Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table DEMO (n int);
begin transaction;
ORA-06550: line 1, column 17:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

   := . ( @ % ;

insert into DEMO values (0);
1 rows affected

select n "after insert" from demo;

after insert

0

update DEMO set n=1/n;
ORA-01476: divisor is equal to zero

select n "after error" from DEMO;

after error

0

commit;
select n "after commit" from DEMO;

after commit

0