Oracle PL/SQL by Example / Edition 3
  • Oracle PL/SQL by Example / Edition 3
  • Oracle PL/SQL by Example / Edition 3

Oracle PL/SQL by Example / Edition 3

by Benjamin Rosenzweig, Benjamin Rosenweig, Elena Silvestrova
     
 

A new edition of this title is available, ISBN-10: 0137144229 ISBN-13: 9780137144228

See more details below

Overview

A new edition of this title is available, ISBN-10: 0137144229 ISBN-13: 9780137144228

Product Details

ISBN-13:
9780131172616
Publisher:
Prentice Hall
Publication date:
09/10/2003
Series:
Prentice Hall Professional Oracle Series
Edition description:
Third Edition
Pages:
735
Product dimensions:
6.94(w) x 9.50(h) x 1.50(d)

Table of Contents

Ch. 1 PL/SQL Concepts 1

Ch. 2 General Programming Language Fundamentals 21

Ch. 3 SQL in PL/SQL 39

Ch. 4 Conditional Control: IF Statements 53

Ch. 5 Conditional Control: CASE Statements 81

Ch. 6 Iterative Control: Part I 113

Ch. 7 Iterative Control: Part II 143

Ch. 8 Error Handling and Built-in Exceptions 163

Ch. 9 Exceptions 179

Ch. 10 Exceptions: Advanced Concepts 211

Ch. 11 Introduction to Cursors 229

Ch. 12 Advanced Cursors 253

Ch 13 Triggers 263

Ch 14 Compound Triggers 291

Ch 15 Collections 315

Ch 16 Records 349

Ch 17 Native Dynamic SQL 379

Ch 18 Bulk SQL 403

Ch 19 Procedures 439

Ch. 20 Functions 449

Ch. 21 Packages 457

Ch. 22 Stored Code 495

Ch. 23 Object Types in Oracle 513

Ch. 24 Oracle Supplied Packages 555

APPENDIX A PL/SQL Formatting Guide 597

APPENDIX B Student Database Schema 601

APPENDIX C ANSI SQL Standards 607

APPENDIX D Answers to the Try It Yourself Sections 613

Index 705

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >