Oracle PL/SQL Interactive Workbook
Autor Benjamin Rosenzweig, Benjamin Rosenweig, Elena Silvestrovaen Limba Engleză Paperback – noi 2002
Appropriate for beginning to intermediate courses in Oracle PL/SQL.
Fully updated and expanded for Oracle 9i, this integrated book-and-Web learning solution is designed to help students master Oracle PL/SQL as quickly as possible. Its unique workbook-based pedagogy incorporates hands-on, real-world labs, exercises, and projects, as well as an outstanding Web-based training site containing Test Your Thinking project solutions and detailed explanations; additional self-review exercises with instant feedback and explanations; and an exclusive Virtual Study Lounge where students can interact with each other. The book's coverage includes every fundamental PL/SQL concept, skill, and technique, including PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, and packaging-plus powerful new techniques for working with exceptions, cursors, collections, and records.
Preț: 203.83 lei
Preț vechi: 254.80 lei
-20%
39.05€ • 42.30$ • 33.49£
Cartea nu se mai tipărește
Specificații
ISBN-10: 0130473200
Pagini: 688
Ilustrații: illustrations
Dimensiuni: 175 x 239 x 36 mm
Greutate: 1.05 kg
Ediția:Nouă
Editura: Prentice Hall
Locul publicării:Upper Saddle River, United States
Descriere
Cuprins
Acknowledgments.
About the Authors.
Introduction.
1. Programming Concepts.
LAB 1.1 The Nature of a Computer Program and Programming Languages. LAB 1.2 Good Programming Practices. 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. Nested Blocks, and Labels. Chapter 3 Test Your Thinking.
4. SQL in PL/SQL.
LAB 4.1 Making Use of DML in PL/SQL. LAB 4.2 Making Use of SAVEPOINT. Chapter 4 Test Your Thinking.
5. Conditional Control: IF Statements.
LAB 5.1 IF Statements. LAB 5.2 ELSIF Statements. LAB 5.3 Nested IF Statements. Chapter 5 Test Your Thinking.
6. Conditional Control: Case Statements.
LAB 6.1 CASE Statements. LAB 6.2 CASE Expressions. LAB 6.3 NULLIF and COALESCE Functions. Chapter 6 Test Your Thinking.
7. Error Handling and Built-In Exceptions.
LAB 7.1 Handling Errors. LAB 7.2 Built-In Exceptions. Chapter 7 Test Your Thinking.
8. Iterative Control.
LAB 8.1 Simple Loops. LAB 8.2 WHILE Loops. LAB 8.3 Numeric FOR Loops. LAB 8.4 Nested Loops. Chapter 8 Test Your Thinking.
9. Introduction to Cursors.
LAB 9.1 Cursor Manipulation. LAB 9.2 Using Cursor FOR Loops and Nesting Cursors. Chapter 9 Test Your Thinking.
10. Exceptions.
LAB 10.1 Exception Scope. LAB 10.2 User-Defined Exceptions. LAB 10.3 Exception Propagation. Chapter 10 Test Your Thinking.
11. Exceptions: Advanced Concepts.
LAB 11.1 RAISE_APPLICATION_ERROR. LAB 11.2 EXCEPTION_INIT Pragma. LAB 11.3 SQLCODE and SQLERRM. Chapter 11 Test Your Thinking.
12. Procedures.
LAB 12.1 Creating Procedures. LAB 12.2 Passing Parameters In and Out of Procedures. Chapter 12 Test Your Thinking.
13. Functions.
LAB 13.1 Creating and Using Functions. Chapter 13 Test Your Thinking.
14. Packages.
LAB 14.1 The Benefits of Utilizing Packages. Chapter 14 Test Your Thinking.
15. Advanced Cursors.
LAB 15.1 Using Parameters with Cursors and FOR UPDATE Cursors. LAB 15.2 Cursor Variables. Chapter 15 Test Your Thinking.
16. Stored Code.
LAB 16.1 Gathering Stored Code Information. Chapter 16 Test Your Thinking.
17. Triggers.
LAB 17.1 What Triggers Are. LAB 17.2 Types of Triggers. LAB 17.3 Mutating Table Issues. Chapter 17 Test Your Thinking.
18. Collections.
LAB 18.1 PL/SQL Tables. LAB 18.2 Varrays. LAB 18.3 Multilevel Collections. Chapter 18 Test Your Thinking.
19. Records.
LAB 19.1 Records. LAB 19.2 Nested Records. LAB 19.3 Collections of Records. Chapter 19 Test Your Thinking.
Appendix A. Answers to Self-Review Questions.
Appendix B. PL/SQL Formatting Guide.
Appendix C. Student Database Schema.
Appendix D. Answers to Test Your Thinking Sections.
Appendix E. Oracle 9i SQL New Features.
Index.
Notă biografică
ELENA SILVESTROVA, a senior software engineer for a prominent New York brokerage firm and securities dealer, has taught relational database programming in Columbia University's CTA program during the past four years. She studied analysis and design at Columbia University and applied mathematics at Baku State University in Azerbaijan.
Textul de pe ultima copertă
- Build Oracle PL/SQL applications--now.
- Fully updated for Oracle 9i
- No Oracle PL/SQL experience necessary.
- Real-life labs and "Test Your Thinking" Q&As
Start developing applications with Oracle PL/SQL--fast. This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, exercises, projects, and a complete Web-based training site. Completely updated for Oracle 9i, it covers all the fundamentals--and a whole lot more. Master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, and packaging--plus powerful new techniques for working with exceptions, cursors, collections, and records. Your free Web-based training module includes a Virtual Study Lounge where you can interact with other learners, work on new projects, and get updates.
Totally integrated with a FREE, state-of-the-art Oracle 9i learning Web site.
Every Prentice Hall Oracle Interactive Workbook is fully integrated with its own exclusive Web site, giving you all this and more:
- "Test Your Thinking" project solutions and detailed explanations
- Additional self-review exercises with instant feedback and explanations
- An exclusive Virtual Study Lounge where you can interact with other students.
Just the facts. No endless, boring discussions here. You'll learn hands on through practical exercises, self-review questions, and real-world answers. Exclusive "Test Your Thinking" projects guarantee you'll go beyond rote knowledge to really master the subject. It's an integrated learning system that's proven to work.
Dozens of exercises cover the real-world tasks that matter most.
Hundreds of self-review questions and answers make sure you understand.
Caracteristici
- NEW - Fully updated and expanded to reflect Oracle 9i's version of PL/SQL.
- Helps students rapidly master the most valuable features incorporated in the latest version of Oracle PL/SQL.
- Helps students rapidly master the most valuable features incorporated in the latest version of Oracle PL/SQL.
- Uniquely effective hands-on workbook format—Gives students hands-on practice through real-world exercises, labs, and projects.
- Helps students master Oracle PL/SQL more rapidly and retain more of what they learn.
- Helps students master Oracle PL/SQL more rapidly and retain more of what they learn.
- Comprehensive coverage of Oracle PL/SQL fundamentals—Covers syntax, program control, scoping, datatypes, cursors, triggers, security, tables, packaging, exceptions, cursors, collections, records, and more.
- Gives students a single resource for learning all the Oracle PL/SQL skills they are likely to need.
- Gives students a single resource for learning all the Oracle PL/SQL skills they are likely to need.
- Web-based training module—Supports the book with an extensive, integrated set of online features.
- Gives students access to constant updates on even more learning resources.
- Gives students access to constant updates on even more learning resources.
- By two of the world's leading database educators—Authored by Ben Rosenzweig and Elena Silvestrova, faculty members in the Database Application Development and Design track at Columbia University's School of Continuing Education.
- Lets students benefit from authoritative coverage by leading experts in both database technology and database instruction.
- Lets students benefit from authoritative coverage by leading experts in both database technology and database instruction.
- Virtual Study Lounge—Provides an online venue where students can interact with each other.
- Helps students resolve their own questions and learn from each other.
- Helps students resolve their own questions and learn from each other.
Caracteristici noi
- Fully updated and expanded to reflect Oracle 9i's version of PL/SQL.
- Helps students rapidly master the most valuable features incorporated in the latest version of Oracle PL/SQL.
- Helps students rapidly master the most valuable features incorporated in the latest version of Oracle PL/SQL.