Book description
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.
Table of contents
- Copyright
- The Prentice Hall PTR Oracle Series
- Acknowledgments
- About the Authors
- Introduction
- About Prentice Hall Professional Technical Reference
- Programming Concepts
- PL/SQL Concepts
- General Programming Language Fundamentals
- SQL in PL/SQL
- Conditional Control: IF Statements
- Conditional Control: Case Statements
- Error Handling and Built-In Exceptions
- Iterative Control
- Introduction to Cursors
- Exceptions
- Exceptions: Advanced Concepts
- Procedures
- Functions
- Packages
- Advanced Cursors
- Stored Code
- Triggers
- Collections
- Records
-
Answers to Self-Review Questions
- Chapter 1 Programming Concepts
- Chapter 2 PL/SQL Concepts
- Chapter 3 General Programming Language Fundamentals
- Chapter 4 SQL in PL/SQL
- Chapter 5 Conditional Control: IF Statements
- Chapter 6 Conditional Control: CASE Statements
- Chapter 7 Error Handling and Built-In Exceptions
- Chapter 8 Iterative Control
- Chapter 9 Introduction to Cursors
- Chapter 10 Exceptions
- Chapter 11 Exceptions: Advanced Concepts
- Chapter 12 Procedures
- Chapter 13 Functions
- Chapter 14 Packages
- Chapter 15 Advanced Cursors
- Chapter 16 Stored Code
- Chapter 17 Triggers
- Chapter 18 Collections
- Chapter 19 Records
- PL/SQL Formatting Guide
- Student Database Schema
-
Answers to Test Your Thinking Sections
- Chapter 1 Programming Concepts
- Chapter 2 PL/SQL Concepts
- Chapter 3 General Programming Language Fundamentals
- Chapter 4 SQL in PLSQL
- Chapter 5 Conditional Control: IF Statements
- Chapter 6 Conditional Control: CASE Statements
- Chapter 7 Error Handling and Built-In Exceptions
- Chapter 8 Iterative Control
- Chapter 9 Introduction to Cursors
- Chapter 10 Exceptions
- Chapter 11 Exceptions: Advanced Concepts
- Chapter 12 Procedures
- Chapter 13 Functions
- Chapter 14 Packages
- Chapter 15 Stored Code
- Chapter 17 Triggers
- Chapter 18 Collections
- Chapter 19 Records
- Oracle 9i SQL New Features
Product information
- Title: Oracle® PL/SQL® Interactive Workbook, Second Edition
- Author(s):
- Release date: October 2002
- Publisher(s): Pearson
- ISBN: 0130473200
You might also like
book
Oracle Enterprise Manager 10g Grid Control Handbook
Master Oracle Enterprise Manager 10 g Grid Control Centralize and simplify enterprise infrastructure administration using the …
book
Oracle® Database 10g Insider Solutions
Oracle Database 10g Insider Solutions is a must-have reference guide for all Oracle professionals. It provides …
book
Oracle® 11g For Dummies®
Are you a seasoned system administrator charged with setting up an Oracle database? Or did you …
book
Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)
Whether you're studying for the Oracle 9i Fundamentals I exam or just need to take the …