This book deals extensively with the PL/SQL programming language (Procedural Language/SQL) that is used to access and work with Oracle databases from different environments. PL/SQL extends the functionality of the SQL language by adding the typical structures of procedural languages, such as blocks, variables and types, control structures (loops, if-then-else orders, etc.), cursors, procedures and functions, packages, triggers, types of objects and methods, exceptions and other conventional structures in procedural programming languages. It is a robust and powerful language that combines the flexibility of SQL with the power and configurability of procedural constructions and incorporates the features of object-oriented programming languages.
In terms of methodology, in successive chapters the concepts are presented and illustrated with examples. The practical structure of the book is reflected in the series of 260 fully solved exercises at the end of the chapters composing the book, which support the theoretical concepts and clarify them. The databases used in examples and exercises are incorporated into the text. It also uses the Oracle database installed by default. This way, it is not necessary to resort to external sources or other information.