Oracle Pl/sql For Dbas

by Nanda, Arup

• ISBN13: 9780596005870
• ISBN10: 0596005873
• Format: Paperback
• Copyright: 2005-11-01
• Publisher: Oreilly & Associates Inc

Summary

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.

Author Biography

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.

Table of Contents

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