Oracle PL/SQL by Example (Prentice Hall PTR Oracle Ser.) / Edition 4

Oracle PL/SQL by Example (Prentice Hall PTR Oracle Ser.) / Edition 4

4.0 2
by Benjamin Rosenzweig, Elena Silvestrova Rakhimov
     
 

ISBN-10: 0137144229

ISBN-13: 9780137144228

Pub. Date: 09/04/2008

Publisher: Prentice Hall

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

…  See more details below

Overview

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

Read More

Product Details

ISBN-13:
9780137144228
Publisher:
Prentice Hall
Publication date:
09/04/2008
Series:
Prentice Hall Professional Oracle Series
Edition description:
Older Edition
Pages:
740
Product dimensions:
7.00(w) x 9.00(h) x 1.60(d)

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

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Oracle PL/SQL by Example (Prentice Hall PTR Oracle Ser.) 4 out of 5 based on 0 ratings. 2 reviews.
Anonymous More than 1 year ago
Anonymous More than 1 year ago