Kas protseduuris teostatakse mitu DML-operatsiooni ühes transaktsioonis?

In most database management systems (DBMS), if not specified otherwise in a procedure, all DML operations (INSERT, UPDATE, DELETE) are executed within a single transaction. This means that either all changes are applied, or in case of an error, all changes are rolled back.

For example, in PL/SQL or T-SQL, if a procedure is called without explicit transaction management, the transaction begins with the first DML and ends with a commit or rollback at the end of the procedure.