Oracle PL/SQL for DBAs

Front Cover
"O'Reilly Media, Inc.", Oct 31, 2005 - Computers - 456 pages
0 Reviews

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(RLS), Fine-Grained Auditing (FGA); and random value generation
  • Methods for DBAs to improve query and database performance with cursors and table functions
  • Coverage of Oracle scheduling, which allows jobs such as database monitoring andstatistics gathering to be scheduled for regular execution

Using Oracle's built-in packages (DBMS_CRYPTO, DBMS_RLS, DBMS_FGA, DBMS_RANDOM,DBMS_SCHEDULING) as a base, the book describes ways of building on top of these packages to suit particular organizational needs. Authors are Arup Nanda, Oracle Magazine 2003 DBA of the Year, and Steven Feuerstein, the world's foremost PL/SQL expert and coauthor of the classic reference, Oracle PL/SQL Programming.

DBAs who have not yet discovered how helpful PL/SQL can be will find this book a superb introduction to the language and its special database administration features. Even if you have used PL/SQL for years, you'll find the detailed coverage in this book to be an invaluable resource.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Preface
Introduction to PLSQL 1
Cursors 81
Data Encryption and Hashing 156
RowLevel Security 221
FineGrained Auditing 268
Scheduling 327
A Quick Reference 373
Index 407
Copyright

Common terms and phrases

About the author (2005)

Arup Nanda has been an Oracle?Database administrator?since 1993, which has exposed him to all facets of database administration, from modeling to disaster recovery. He currently leads the global DBA team at Starwood Hotels, the parent of chains such as Sheraton and Westin, in White Plains, New York. He serves as a contributing editor of "SELECT Journal", the publication of Independent Oracle Users Group (IOUG); speaks at many Oracle Technology events such as Oracle World and local user groups such as New York Oracle User Group; and has written many articles for both print publications such as "Oracle Magazine" and online publications such as "Oracle Technology Network". Arup has co-authored two books: "Oracle Privacy Security Auditing" (Rampant, 2003) and "Oracle PL/SQL for DBAs" (O'Reilly, 2005). Recognizing his professional accomplishments and contributions to user community, Oracle chose him as the DBA of the Year in 2003. Arup lives in Danbury, Connecticut, with his wife, Anindita, and son, Anish. He can be reached at arup@proligence.com

Steven Feuerstein is considered to be one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). He has also published his first book for kids: http: //stevenfeuerstein.com/vivianvulture. Steven currently serves as PL/SQL Evangelist for Oracle Corporation. He has been developing software since 1980, spent five years with Oracle (1987-1992), and was PL/SQL Evangelist for Quest Software (and then Dell) from January 2001 to February 2014. He was an Oracle ACE Director (had to give up the prestigious title when he rejoined Oracle) and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG's Lifetime Achievement Award (2009). Steven's latest initiative is the PL/SQL Challenge ( http: //www.plsqlchallenge.com ), a daily quiz for PL/SQL developers; hundreds of programmers play each day. Check it out and join the fun! You can also catch up on his latest, mostly non-PLSQL rants at http: //feuerthoughts.blogspot.com.

Bibliographic information