Product Cover Image

Oracle PL/SQL by Example, Safari, 4th Edition

By Benjamin Rosenzweig, Elena Rakhimov

Published by Prentice Hall

Published Date: Aug 12, 2008

More Product Info

Description

This integrated learning solution teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects! Completely updated for Oracle 11g, Oracle PL/SQL by Example, Fourth Edition covers all the fundamentals, from PL/SQL syntax and program control through packages and Oracle 11g’s significantly improved triggers.

 

One step at a time, you’ll walk through every key task, discovering the most important PL/SQL programming techniques on your own. Building on your hands-on learning, the authors share solutions that offer deeper insights and proven best practices. End-of-chapter projects bring together all the techniques you’ve learned, strengthening your understanding through real-world practice.

 

This book’s approach fully reflects the authors’ award-winning experience teaching PL/SQL programming to professionals at Columbia University. New database developers and DBAs can use its step-by-step instructions to get productive fast; experienced PL/SQL programmers can use this book as a practical solutions reference. Coverage includes

        • Mastering basic PL/SQL concepts and general programming language fundamentals, and understanding SQL’s role in

          PL/SQL

        • Using conditional and iterative program control techniques, including the new CONTINUE and CONTINUE WHEN statements

        • Efficiently handling errors and exceptions

        • Working with cursors and triggers, including Oracle 11g’s powerful new compound triggers

        • Using stored procedures, functions, and packages to write modular code that other programs can execute

        • Working with collections, object-relational features, native dynamic SQL, bulk SQL, and other advanced PL/SQL capabilities

        • Handy reference appendices: PL/SQL formatting guide, sample database schema, ANSI SQL standards reference, and

          more

Table of Contents

Acknowledgments                                                                          

About the Authors

Introduction  

                                                                                 

Chapter 1 PL/SQL Concepts                                                    

Chapter 2 General Programming Language Fundamentals           

Chapter 3 SQL in PL/SQL                                                        

Chapter 4 Conditional Control: IF Statements                            

Chapter 5 Conditional Control: CASE Statements                      

Chapter 6 Iterative Control: Part 1                                              

Chapter 7 Iterative Control: Part 2                                              

Chapter 8 Error Handling and Built-In Exceptions                      

Chapter 9 Exceptions                                                                

Chapter 10 Exceptions: Advanced Concepts                              

Chapter 11 Introduction to Cursors                                           

Chapter 12 Advanced Cursors                                                  

Chapter 13 Triggers                                                                  

Chapter 14 Compound Triggers                                                

Chapter 15 Collections                                                              

Chapter 16 Records                                                                  

Chapter 17 Native Dynamic SQL                                               

Chapter 18 Bulk SQL                                                                          

Chapter 19 Procedures                                                              

Chapter 20 Functions                                                                

Chapter 21 Packages                                                                 

Chapter 22 Stored Code                                                           

Chapter 23 Object Types in Oracle                                            

Chapter 24 Oracle Supplied Packages                                        

Appendix A  PL/SQL Formatting Guide                                      

Appendix B  Student Database Schema                                       

Appendix C  ANSI SQL Standards                                             

Appendix D  Answers to Try it Yourself Sections             

 

Purchase Info

ISBN-10: 0-13-715168-3

ISBN-13: 978-0-13-715168-4

Format: Safari PTG

This publication is not currently for sale.