Higher Education

Oracle 10g Developer: PL/SQL Programming, 1st Edition

  • Joan Casteel Tidewater Community College
  • ISBN-10: 1423901363  |  ISBN-13: 9781423901365
  • 560 Pages
  • Previous Editions: 2003
  • © 2008 | Published
  • College Bookstore Wholesale Price = $138.00
  • Newer Edition Available



Learn how to use the PL/SQL programming language effectively, using one of the most popular and widely-used software programs in large companies today. Oracle 10g Developer: PL/SQL Programming uses Oracle 10g to provide an overview of the PL/SQL programming language, beginning with fundamental PL/SQL concepts and progressing to the writing and testing of PL/SQL code. The book then progresses to more advanced topics, such as Dynamic SQL and code tuning. Updated to the latest release, Oracle 10g, it uses the developer's perspective to focus on the PL/SQL component of the software. With real-world examples and a straightforward writing style, this is a valuable resource for anyone preparing for the new Oracle Certification exam, or simply looking to master the PL/SQL programming language with Oracle.

Features and Benefits

  • In-chapter challenges and hands-on assignments throughout the book using SQL*Plus offers readers the opportunity to apply the material covered.
  • Step-by step tutorials break down difficult concepts into smaller, more comprehensible, pieces
  • Case projects in every chapter and a running business case provide a context for the topics covered, preparing readers for real-life scenarios
  • Appendices introduce common tools used to develop PL/SQL programs—the new Oracle SQL Developer and the ever popular TOAD (Tool for Oracle Application Developers).

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. Program Unit Dependencies
9. Database Triggers
10. Oracle-Supplied Packages and SQL*Loader
11. Introduction to Dynamic SQL and Object Technology
A. Tables for the Brewbean's Database
B. Oracle SQL Developer
C. TOAD (Tool for Oracle Application Developers)
D. Statement Tuning

Learning Resource Bundles

Choose the textbook packaged with the resources that best meet your course and student needs. Contact your Learning Consultant for more information.

Bundle: Oracle 10g Developer: PL/SQL Programming + Oracle 11G: SQL, 2nd

ISBN-10: 1111198098 | ISBN-13: 9781111198091

List Price = $345.95  | College Bookstore Wholesale Price = $260.25

This Bundle Includes:

  • Oracle 11G: SQL
    List Price = $132.95  | College Bookstore Wholesale Price = $100.00
  • Oracle 10g Developer: PL/SQL Programming
    List Price = $183.95  | CengageBrain Price = $183.95  | College Bookstore Wholesale Price = $138.00


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 Resource CD-ROM  (ISBN-10: 1423901533 | ISBN-13: 9781423901532)

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.