-- Transações

-- Teste 1
begin transaction;
insert into autor(id,nome) values (7,"Tiago");
rollback;


-- Teste 2
begin transaction;
insert into autor(id,nome) values (8,"Tiago");
commit;


begin transaction;
delete from autor where id=5;
commit;



commit;

select * from autor;


