Images

CHAPTER 9

PL/SQL for Automation and Administration

This chapter is all about what PL/SQL has to offer to those of us who administer databases and automate tasks—and it offers us a lot. PL/SQL can help us have easier jobs with less drudgery, leaving us more time for the more interesting, complex parts of our working lives.

The lack of the acronym DBA in the chapter’s title is significant. There is a lot here that we hope DBAs will find helpful, but much of it is also of use to PL/SQL developers. Writing tools and utilities in PL/SQL can make the life of a production DBA a lot easier, and a lot of traditionally DBA-type tasks can be achieved with ...

Get Real World SQL and PL/SQL: Advice from the Experts now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.