Oracle PL/SQL Interactive Workbook

Oracle PL/SQL Interactive Workbook

3.75 (4 ratings by Goodreads)
  • Paperback
By (author)  , By (author) 

List price: US$39.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

Part of the PH PTR Interactive's ground-breaking Interactive Workbook Series. This is the first of four entries in the Oracle Interactive Workbook Series. This book focuses on PL/SQL. PL/SQL is a programming language used in Oracle Tools (such as Oracle Developer) and in the database itself as stored procedures. It is essential for oracle DBAs and Oracle Developers to learn this language to work in the Oracle environment.show more

Product details

  • Paperback | 447 pages
  • 177.8 x 246.4 x 33mm | 884.5g
  • Pearson Education (US)
  • Prentice Hall
  • Upper Saddle River, United States
  • 0130157430
  • 9780130157430

Table of contents

1. programming concepts. Lab 1.1 The Nature of a Computer Program and Programming Languages. Lab 1.2 good Programming Practices. Structured Programming. CHAPTER 1 Test Your Thinking. 2. pl/sql concepts. Lab 2.1 pl/sql in Client-Server Architecture. Lab 2.2 PL/SQL in SQL*Plus. CHAPTER 2 Test Your Thinking. 3. General Programming Language Fundamentals. Lab 3.1 PL/SQL Programming Fundamentals. CHAPTER 3 Test Your Thinking. 4. SQL in PL/SQL. Lab 4.1 Making use of DML in PL/QL. Lab 4.2 Making Use of Savepoint. CHAPTER 4 Test Your Thinking. 5. conditional Control. Lab 5.1 if Statements. Lab 5.2 Elsif Statements. Lab 5.3 Nested If Statements. CHAPTER 5 Test Your Thinking. 6. Exception Handling and Built-In Exceptions. Lab 6.1 Handling Errors. Lab 6.2 Built-in Exceptions. CHAPTER 6 Test Your Thinking. 7. Iterative Control. Lab 7.1 Simple LOOPs. Lab 7.2 WHILE LOOPs. Lab 7.3 Numeric for LOOPs. Lab 7.4 Nested LOOPs. CHAPTER 7 Test Your Thinking. 8. Introduction to Cursors. Lab 8.1 Cursor Manipulation. Lab 8.2 Using Cursor for Loops and Nesting Cursors. Lab 8.3 Using PARAMETERS with Cursors and For Update Cursors. CHAPTER 8 Test Your Thinking. 9. Exceptions. Lab 9.1 Exception Scope. Lab 9.2 USER-DEFINED Exceptions. Lab 9.3 Exception Propagation. CHAPTER 9 Test Your Thinking. 10. exceptions: Advanced Concepts. Lab 10.1 raise_application_error. Lab 10.2 exception_init pragma. Lab 10.3 sqlcode and sqlerrm. CHAPTER 10 Test Your Thinking. 11. Procedures. Lab 11.1 Creating Procedures. Lab 11.2 Passing parameters in and out of Procedures. CHAPTER 11 Test Your Thinking. 12. functions. Lab 12.1 Creating and USING Functions. CHAPTER 12 Test Your Thinking. 13. Packages. Lab 13.1 The Benefits of Utilizing Packages. CHAPTER 13 Test Your Thinking. 14. Stored Code. Lab 14.1 Advanced Features of Stored Code. CHAPTER 14 Test Your Thinking. 15. triggers. Lab 15.1 What Triggers Are. Lab 15.2 Types of Triggers. Lab 15.3 Mutating Table Issues. CHAPTER 15 Test Your Thinking. 16. PL/SQL Tables. Lab 16.1 Making Use of PL/SQL Tables. CHAPTER 16 Test Your Thinking. Appendix A: Answers to Self-Review Questions. Appendix B: PL/SQL Formatting Guide. Appendix C: Student Database Scheme. Index.show more

About Benjamin Rosenzweig

Benjamin Rosenzweig and Elena Silvestrova are faculty members at the Columbia University School of Continuing Education. Series Technical Advisor Douglas Scherer is a certified Oracle database administrator, and President and Founder of Core Paradigm, Inc. He has been an Oracle specialist, database architect, and consultant to a wide range of leading companies, including Deutsche Bank. He is also a member of the faculty at the Columbia University School of Continuing Education.show more

Rating details

4 ratings
3.75 out of 5 stars
5 25% (1)
4 50% (2)
3 0% (0)
2 25% (1)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X