PL/ SQL

From MaRDI portal





The book is devoted to a detailed exposition of the programming language PL/SQL. The language can be used only over the Oracle database system. The book is motivated by a positive experience with a use of PL/SQL as an interface between a database on the one hand and an object-oriented client-server application on the other hand. The first chapter provides an introduction to Oracle and SQL (for the readers not familiar with the necessary background of the PL/SQL). In the second chapter a basic look on the PL/SQL architecture is introduced. PL/SQL represents an extension of the SQL language by some procedural elements. A goal of the development of PL/SQL was to enable a processing of some associated database operations on the server. In the third chapter the SQL*Plus environment is presented. The environment is described in a scope necessary for the PL/SQL programming. The elements of the PL/SQL language are described in detail in the fourth chapter, the most extensive part of the book (pp. 49-200 of the total of 306 pages). The language is easy to learn for a programmer familiar with a programming language of the procedural paradigm (as C language, for example). PL/SQL, as an interface to Oracle contains also mechanisms of transactions management, cursor handling and exceptions handling. The description of the language constructs is supplemented by a set of useful examples. The topics of the rest of the book are: modules; triggers; dependent database objects (referenced in other database objects), their status and the status changes; privileges and security aspects; PL/SQL programs development and debugging; application domains of PL/SQL. The last part of the book contains a description of the standard packages.






Describes a project that uses

Uses Software






This page was built for publication: PL/ SQL

Report a bug (only for logged in users!)Click here to report a bug for this page (MaRDI item Q4342009)