Oracle PL/SQL. Developer"s Guide

PL/SQL is a software that is used not only by the developers of the database application, but also the administrators in their daily work. This book contains everything you need to know to each developer and administrator of the database. The book offers detailed information on the PL/SQL programming language, analysis, setting up, monitoring productivity and code security from hackers. The book discusses numerous examples and useful scripts. At the end of each chapter, questions are given for exam 1z0-146.
The main topics of the book:

- Review of the concept of programming on PL /SQL,

- designing code PL /SQL,

- the use of collections,

- the use of extended interface methods,

- the use of virtual private databases (VPD) with subtle control control of FGAC,

- Work with large objects,

- Using secretfiles,

- compilation and setting to improve performance,

- Caching,

- Analysis of the PL /SQL code,

- Profilation and tracking of the execution of the code PL /SQL,

- Protection of the PL /SQL code from SQL attacks