Oracle PL/SQL: Expert Techniques For Developers and Database Administrators

Oracle PL/SQL: Expert Techniques For Developers and Database Administrators

5.0 1
by Lakshman Bulusu
     
 


Welcome aboard the first book focusing exclusively on PL/SQL techniques, through Oracle 11g. These techniques are tried-tested-true, yet do not compromise performance. You'll find coverage of all types of scenarios, starting from design to coding and testing to debugging and tuning. PL/SQL is more than just a 3GL sequel to SQL; instead it can be used as a… See more details below

Overview


Welcome aboard the first book focusing exclusively on PL/SQL techniques, through Oracle 11g. These techniques are tried-tested-true, yet do not compromise performance. You'll find coverage of all types of scenarios, starting from design to coding and testing to debugging and tuning. PL/SQL is more than just a 3GL sequel to SQL; instead it can be used as a methodology for application development using Oracle. The techniques covered here have a broader scope, in applications ranging from OLTP to OLAP and from data warehousing to business intelligence. The world of PL/SQL is exciting and this book provides a repository of techniques for PL/SQL developers and DBAs alike. This book takes you beyond the existing solutions found in other professional and reference texts or in online documentation. Starting from PL/SQL internals that include PL/SQL program structure, internal representation, compilation, and execution, users are taught PL/SQL concepts and techniques that go way beyond SQL, such as data structure management, error management, data management, application management, and transaction management. It covers the practical "how-to" techniques of applying these PL/SQL concepts in live projects and elaborates on various PL/SQL frameworks, the integration of PL/SQL with Java, and Web-enabling PL/SQL. The last two chapters on PL/SQL tuning and debugging and PL/SQL coding standards contain comprehensive coverage of performance-enhancing techniques and PL/SQL coding standards that can't be found in anywhere else. All techniques include examples and hands-on code, as well as tips and coding standards. The companion CD-ROM includes all the source code for the examples in the book.

Read More

Product Details

ISBN-13:
9781584505549
Publisher:
Cengage Learning
Publication date:
04/03/2008
Series:
Charles River Media Programming Ser.
Edition description:
New Edition
Pages:
352
Sales rank:
1,360,500
Product dimensions:
9.14(w) x 7.70(h) x 0.85(d)

Related Subjects

Table of Contents


Part I: Introductory Concepts Chapter 1: Introduction to PL/SQL Chapter 2: PL/SQL by Dissection Chapter 3: New Features in PL/SQL Part II: Techniques for PL/SQL Programming Chapter 4: Data Structure Management in PL/SQL Chapter 5: Error Management in PL/SQL Chapter 6: Data Management in PL/SQL Chapter 7: Application Management in PL/SQL Chapter 8: Transaction Management in PL/SQL Part III: Applying PL/SQL in the real world Chapter 9: Application Development Frameworks Using PL/SQL Chapter 10: Applying PL/SQL in 3GL and Web Environment Chapter 11: Miscellaneous Techniques Chapter 12: PL/SQL Tuning and Debugging Chapter 13: PL/SQL Coding Standards

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >