© Stefan Ardeleanu 2016

Stefan Ardeleanu, Relational Database Programming, 10.1007/978-1-4842-2080-1_8

8. Row Triggers and the Need for Atomic Solutions

Stefan Ardeleanu

(1)Bucharest, Romania

Any relational database has a variety of logical and procedural objects, some of them quite classic and inherited from other languages, like the scalar function or stored procedure. The scalar function is clearly oriented per row, so it is an atomic object. Apart from the traditional objects, there are database-specific objects, and the trigger is maybe the most common one. As you probably know, there are many types of triggers, such as statement triggers and row triggers. In a way, the row trigger is very similar to the scalar function, because it is a row-oriented ...

Get Relational Database Programming: A Set-Oriented Approach now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.