Higher Education

Oracle® 11g: PL/SQL Programming, 2nd Edition

  • Joan Casteel Tidewater Community College
  • ISBN-10: 1133947360  |  ISBN-13: 9781133947363
  • 528 Pages
  • Previous Editions: 2008, 2003
  • © 2013 | Published
  • College Bookstore Wholesale Price = $124.50
  *Why an online review copy?
  • It's the greener, leaner way to review! An online copy cuts down on paper and on time. Reduce the wait (and the weight) of printed texts. Your online copy arrives instantly, and you can review it anytime from your computer or favorite mobile device.

If you prefer a print copy to review, please contact your representative.



Teach your students how to use the PL/SQL programming language effectively as you introduce them to one of the most popular and widely used software programs in large companies: Oracle® 11g. Casteel's ORACLE 11g: PL/SQL PROGRAMMING, 2E, uses Oracle 11g to give students an overview of the PL/SQL programming language. It's the only book of its kind designed specifically for classroom use and certification preparation with instructional support resources and student assignments. The author begins with a step-by-step expanded introduction to fundamental PL/SQL concepts before progressing to writing and testing PL/SQL code. This edition also covers more advanced topics, such as dynamic SQL and compound triggers, as well as important developments in bulk processing, PL/SQL compiler features, and hiding source code. Updates throughout reflect the latest Oracle 11g release, and figures and examples are shown in the user-friendly SQL Developer tool. The book is written from a developer's perspective to focus on the PL/SQL component of Oracle, using numerous real-world examples and a straightforward writing style. This book, and a complete instructor support package, offers the resources you need to help students prepare for the new Oracle certification exam or simply master the PL/SQL programming language with Oracle.

Features and Benefits

  • IN-CHAPTER EXERCISES AND HANDS-ON ASSIGNMENTS GIVE STUDENTS IMPORTANT OPPORTUNITIES FOR PRACTICE. Varied in-chapter exercises and a wealth of hands-on assignments throughout this edition give your students numerous opportunities to better understand and apply the material covered in each chapter.
  • STEP-BY-STEP TUTORIALS DIVIDE CONCEPTS INTO UNDERSTANDABLE SEGMENTS. To make sure all readers gain a thorough understanding of even the most challenging PL/SQL concepts, the author breaks down difficult concepts into smaller, more comprehensible pieces by using a step-by-step tutorial approach.
  • CONTINUING CASE PROJECTS PLACE CONCEPTS INTO A MEANINGFUL CONTEXT FOR READERS. In addition to regular case projects, every chapter has a continuing case project involving a hypothetical movie rental company to show how chapter topics are applied and prepare readers to use concepts in real-life business settings.
  • A UNIQUE APPROACH TAILORED FOR CLASSROOM USE AND CERTIFICATION PREPARATION GIVES YOU CRITICAL INSTRUCTIONAL TOOLS. This is the only book covering PL/SQL and Oracle® 11g concepts that is designed specifically for classroom use and certification preparation. For this reason, you'll find a wealth of useful instructor resources, including a variety of student assignments and presentation materials for your classroom use.
  • THE CONTENT MIRRORS TOPICS NEEDED FOR SUCCESS ON THE LATEST PL/SQL ORACLE® CERTIFICATION EXAM. This edition addresses all the topics needed to prepare for the PL/SQL Oracle certification exam, including content reflected in the new Oracle® 11g exam.
  • COMBINING THE SQL AND PL/SQL BOOKS IN THIS SUCCESSFUL SERIES PREPARES READERS FOR ALL TESTING NEEDED TO BECOME ORACLE CERTIFIED. By combining the instructional approach and content in both the SQL and PL/SQL books in this series, your students have all the information needed for the two certification tests required to become an OCA (Oracle® Certified Associate).
  • ONLINE APPENDIXES INTRODUCE SOME COMMON PL/SQL TOOLS USED TODAY AND ADDITIONAL TOPICS BEYOND CERTIFICATION. Useful appendixes in this edition give you the choice to introduce some common tools used to develop PL/SQL programs, including the new Oracle® SQL Developer and the ever-popular TOAD (Tool for Oracle® Application Developers). Additional appendixes introduce SQL*Loader, statement tuning, and object technology concepts.

Table of Contents

1. Introduction to PL/SQL.
2. Basic PL/SQL Block Structures.
3. Handling Data in PL/SQL Blocks.
4. Cursors and Exception Handling.
5. Procedures.
6. Functions.
7. PL/SQL Packages.
8. Dependencies, Privileges, and Compilation.
9. Database Triggers.
10. Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code.
A. Tables for the Brewbean's Database.
B. Oracle Installation and Using Oracle SQL Developer.
C. TOAD (Tool for Oracle Application Developers).
D. Statement Tuning.
E. SQL*Loader Utility.
F. An Introduction to Object Technology.

What's New

  • THREE DATABASES EXPAND CHOICES FOR CLASS PRACTICE. This edition offers three databases that extend your selection for class practice questions. A new database has been added to this edition with corresponding assignments that focus on how a charitable organization tracks donations efficiently.
  • THE LATEST EXAMPLES AND FIGURES THROUGHOUT THIS EDITION NOW INCORPORATE THE SQL DEVELOPER TOOL. The updated examples and figures throughout this edition show the user-friendly SQL Developer tool, which is free from Oracle. This interface is much easier than SQL*Plus for students to use.
  • EXPANDED COVERAGE OF PL/SQL FUNDAMENTALS COMBINES WITH NEW COVERAGE OF THE LATEST PL/SQL TOPICS. This edition offers your students even more coverage on important fundamentals to give them solid background needed for working with Oracle and certification. Additional new coverage explains important developments in bulk processing, compound triggers, PL/SQL compiler features (such as parameters, warnings, and conditional compilation), and hiding source code.


All supplements have been updated in coordination with the main title. Select the main title's "About" tab, then select "What's New" for updates specific to title's edition.

For more information about these supplements, or to obtain them, contact your Learning Consultant.

Instructor Supplements

Instructor's Resource CD-ROM  (ISBN-10: 1285167260 | ISBN-13: 9781285167268)

Find all of the teaching and preparation resources you need at your fingertips with this convenient all-in-one-source. The Instructor's Resource CD (IRCD) contains easy-to-access Figure Files, PowerPoint® presentations, complete syllabus, invaluable Instructor's Manual, time-saving Solutions Manual, ExamView™ testbanks and software, and Data Files.

Meet the Author

Author Bio

Joan Casteel

Joan E. Casteel combines more than 15 years of hands-on experience in application development in various business environments with strong teaching skills to clarify important application and software concepts for today's readers. An award-winning instructor, Ms. Casteel serves as associate professor of information technology and business at Tidewater Community College, where she has been an integral part of the Database Specialist curriculum. She has joined a newly formed team at the college in charge of building a campus ID card program to encompass four campuses, using a recently deployed Oracle-based system. In addition the team is developing new Oracle APEX applications to improve college-wide financial services support. Ms. Casteel has been recognized by her colleagues for her professional accomplishments, including creating an Oracle virtual machine image for students and handling recruitment efforts for database specialist career studies. Ms. Casteel is the author of two successful books on Oracle from Course Technology, part of Cengage Learning, covering SQL and PL/SQL which serve as the introductory course sequence in the college’s database career path.