Oracle Pl/sql For Dbas

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. 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.

Arup Nanda is a Senior Oracle DBA with 10 years of experience with a variety of projects using skills in Oracle Database Administration (DBA), Oracle Parallel Server, Performance Tuning, Security Administration, Replication, Distributed Databases, Enterprise Manager, Database Design, XML, System Design, Object-Based Design, Data Modeling, PL/SQL, Pro*C, C, Unix, NT, Shell Scripting. He has an MBA from Xavier Institute of Management, India.

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Programming: Guide to Oracle8i Features, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992. He is currently designing and building Qnxo (www.qnxo.com), the world's first active mentoring software.

Preface

ix

Introduction to PL/SQL

1

(80)

What Is PL/SQL?

1

(1)

Basic PL/SQL Syntax Elements

2

(7)

Program Data

9

(7)

Control Statements

16

(2)

Loops in PL/SQL

18

(2)

Exception Handling

20

(4)

Records

24

(3)

Collections

27

(6)

Procedures, Functions, and Packages

33

(12)

Querying Data

45

(11)

Changing Data

56

(8)

Managing Transactions in PL/SQL

64

(3)

Database Triggers

67

(7)

Dynamic SQL and Dynamic PL/SQL

74

(6)

Conclusion: From Fundamentals to Applying PL/SQL

80

(1)

Cursors

81

(34)

Reusing Cursors

82

(13)

Using Explicit Cursors Versus Implicit Cursors

95

(3)

Soft-Closing Cursors

98

(5)

Using Cursors for More Than Queries

103

(11)

Conclusion

114

(1)

Table Functions

115

(41)

Why Table Functions?

116

(3)

Cursors, Pipelining, and Nesting

119

(6)

Parallelizing Table Functions

125

(8)

Using Table Functions

133

(11)

Table Function Examples

144

(5)

Tips for Working with Table Functions

149

(6)

Conclusion

155

(1)

Data Encryption and Hashing

156

(65)

Introduction to Encryption

157

(8)

Encryption in Oracle9i Database

165

(18)

Encryption in Oracle Database 10g

183

(11)

Key Management in Oracle Database 10g

194

(9)

Transparent Data Encryption in Oracle Database 10g Release 2

203

(5)

Cryptographic Hashing

208

(8)

Building a Practical Encryption System

216

(4)

Conclusion

220

(1)

Row-Level Security

221

(47)

Introduction to RLS

221

(7)

Using RLS

228

(19)

RLS in Oracle Database 10g

247

(6)

Troubleshooting RLS

253

(4)

RLS Interactions with Other Oracle Features

257

(1)

Application Contexts

258

(9)

Conclusion

267

(1)

Fine-Grained Auditing

268

(38)

Introduction to FGA

269

(8)

Customizing FGA

277

(12)

Administering FGA

289

(2)

FGA in Oracle Database 10g

291

(4)

FGA and Other Oracle Auditing Techniques

295

(6)

The Challenge of Non-Database Users

301

(1)

Troubleshooting FGA

302

(2)

Conclusion

304

(2)

Generating Random Values

306

(21)

Generating Random Numbers

307

(7)

Generating Characters

314

(4)

Checking for Randomness

318

(1)

Following Statistical Patterns

319

(7)

Conclusion

326

(1)

Scheduling

327

(46)

Why Schedule Jobs from Within Oracle?

328

(3)

Managing Jobs

331

(7)

Managing the Calendar and Schedule

338

(9)

Managing Named Programs

347

(3)

Managing Priorities

350

(4)

Managing Windows

354

(7)

Managing Logging

361

(5)

Managing Attributes

366

(4)

Conclusion

370

(3)

A. Quick Reference

373

(34)

DBMS_Obfuscation_Toolkit

373

(5)

DBMS_Crypto

378

(5)

DBMS_RLS

383

(3)

DBMS_FGA

386

(4)

DBMS_Random

390

(1)

DBMS_Scheduler

391

(16)

Index

407

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Oracle Pl/sql For Dbas

Summary

Author Biography

Table of Contents

Supplemental Materials