Although primarily a tool for developers, PL / SQL has also become an important tool for database administration, as DBAs are responsible for improving site performance and as the lines between developers and DBAs blur. Covering the latest Oracle version, Oracle Database 10g Release 2 and packed with examples of code and use, containing: Quick tour of the language / PL SQL, providing enough basic information about language fundamentals to get DBAs up and running a wide range of security topics for DBAs: Encryption (including both traditional and new methods of Oracle Transparent Data Encryption, TDE); Row-Level Security ( RLS), fine-grained Auditing (FGA), and the generation of random values for the DBA method to improve query performance and database with the cursor and function table Coverage Oracle scheduling, which allows jobs such as database monitoring and statistics for regular meetings will be scheduled execution Using Oracle's built-in package (DBMS_CRYPTO, DBMS_RLS, DBMS_FGA, DBMS_RANDOM, DBMS_SCHEDULING) as a basis, the book describes the ways to build on this package to meet specific organizational needs. DBAs who have not discovered how helpful PL / SQL to this book will find an extraordinary introduction to the language and features a special database administration.