Postgresql, Autocommit, Oracle.
statement or a PL/SQL block or a procedure call ). Still in Oracle, when a statement fails in a user call, the modifications done by this user call are rolled back, but not the previous modifications. The transaction can continue (like re-try, or do an alternative change): sqlplus