Immutable and blockchain tables in Oracle 19c

This presentation is a continuation of the presentation "Functional paradigm and databases" from HrOUG 2019.Let's recall, in the last few years, functional programming has gained a lot of popularity in relation to imperative programming (note: object-oriented programming is also imperative).Functional programming, like logic programming, is very similar to SQL programming in some ways - it is highly declarative.In the 2019 presentation, we looked at functional and logic programming, and discussed how some ideas from functional programming could be applied to database programming.The main topic was thinking about "functional work" with data in a database:Can we work in a database in a similar way as functional languages work with immutable collections, without UPDATE and DELETE (only with INSERT)?These ideas are not new, they were advocated by Jim Gray (scientist in the field of databases and transaction systems, winner of the Turing Award in 1998) back in the 80s, but recently they have become "modern" again.Oracle positively surprised us and realized these ideas in Oracle DBMS 21c, and then incorporated these realizations in 19c - blockchain tables in version 19.10, and immutable tables in version 19.11.