Toko Buku - ClickBookShop.com - (Oracle PL/SQL By Example, 4e (Updated for Oracle 11g))

Book Description

Benjamin Rosenzweig is a software development manager at Misys Treasury & Capital Markets, where he has worked since 2002. Prior to that he was a principal consultant for more than three years at Oracle Corporation in the Custom Development Department. His computer experience ranges from creating an electronic Tibetan—English dictionary in Kathmandu, Nepal, to supporting presentation centers at Goldman Sachs and managing a trading system at TIAA-CREF. Rosenzweig has been an instructor at the Columbia University Computer Technology and Application program in New York City since 1998. In 2002 he was awarded the Outstanding Teaching Award from the chair and director of the CTA program. He holds a B.A. from Reed College and a certificate in database development and design from Columbia University. His previous books with Prentice Hall are Oracle Forms Developer: The Complete Video Course (ISBN: 0-13-032124-9) and Oracle Web Application Programming for PL/SQL Developers (ISBN: 0-13-047731-1).

Elena Silvestrova Rakhimov has more than 15 years of experience in database development in a wide spectrum of enterprise and business environments, ranging from nonprofit organizations to Wall Street. She currently works at Alea Software, where she serves as Senior Developer and Team Lead. Her determination to stay hands-on notwithstanding, Rakhimov has managed to excel in the academic arena, having taught relational database programming at Columbia University’s highly esteemed Computer Technology and Applications program. She was educated in database analysis and design at Columbia University and in applied mathematics at Baku State University in Azerbaijan.She currently resides in Vancouver, Canada.

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