Skip to content

Oracle PL/SQL for DBAs Security, Scheduling, Performance and More

Best in textbook rentals since 2012!

ISBN-10: 0596005873

ISBN-13: 9780596005870

Edition: 2005

Authors: Arup Nanda, Steven Feuerstein

List price: $44.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

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…    
Customers also bought

Book details

List price: $44.99
Copyright year: 2005
Publisher: O'Reilly Media, Incorporated
Publication date: 11/22/2005
Binding: Paperback
Pages: 456
Size: 7.13" wide x 9.06" long x 1.02" tall
Weight: 1.782
Language: English

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…    

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 & Associates). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992.

Preface
Introduction to PL/SQL
What Is PL/SQL?
Basic PL/SQL Syntax Elements
Program Data
Control Statements
Loops in PL/SQL
Exception Handling
Records
Collections
Procedures, Functions, and Packages
Querying Data
Changing Data
Managing Transactions in PL/SQL
Database Triggers
Dynamic SQL and Dynamic PL/SQL
Conclusion: From Fundamentals to Applying PL/SQL
Cursors
Reusing Cursors
Using Explicit Cursors Versus Implicit Cursors
Soft-Closing Cursors
Using Cursors for More Than Queries
Conclusion
Table Functions
Why Table Functions?
Cursors, Pipelining, and Nesting
Parallelizing Table Functions
Using Table Functions
Table Function Examples
Tips for Working with Table Functions
Conclusion
Data Encryption and Hashing
Introduction to Encryption
Encryption in Oracle9i Database
Encryption in Oracle Database 10g
Key Management in Oracle Database 10g
Transparent Data Encryption in Oracle Database 10g Release 2
Cryptographic Hashing
Building a Practical Encryption System
Conclusion
Row-Level Security
Introduction to RLS
Using RLS
RLS in Oracle Database 10g
Troubleshooting RLS
RLS Interactions with Other Oracle Features
Application Contexts
Conclusion
Fine-Grained Auditing
Introduction to FGA
Customizing FGA
Administering FGA
FGA in Oracle Database 10g
FGA and Other Oracle Auditing Techniques
The Challenge of Non-Database Users
Troubleshooting FGA
Conclusion
Generating Random Values
Generating Random Numbers
Generating Characters
Checking for Randomness
Following Statistical Patterns
Conclusion
Scheduling
Why Schedule Jobs from Within Oracle?
Managing Jobs
Managing the Calendar and Schedule
Managing Named Programs
Managing Priorities
Managing Windows
Managing Logging
Managing Attributes
Conclusion
Quick Reference
DBMS_OBFUSCATION_TOOLKIT
DBMS_CRYPTO
DBMS_RLS
DBMS_FGA
DBMS_RANDOM
DBMS_SCHEDULER
Index