PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur.
Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs fills the gap. Covering the latest Oracle version, Oracle Database 10g Release 2 and packed with code and usage examples, it contains:
- A quick tour of the PL/SQL language, providing enough basic
information about language fundamentals to get DBAs up
and running
- Extensive coverage of security topics for DBAs: Encryption
(including both traditional methods and Oracle's new
Transparent Data Encryption, TDE); Row-Level Security
-
1 Introduction to PL/SQL
2 Cursors
3 Table functions
4 Data encryption and hashing
5 Row-level security
6 Fine-grained auditing
7 Generating random values
8 Scheduling