Buying Options
Oracle PL/SQL Programming, Fifth Edition
Print $69.99
Add to Cart
Print+Ebook $76.99
Add to Cart
Ebook $55.99
(Mobi, PDF, ePub)
Add to Cart
Safari Books Online
Add to Cart
What is this?
Print £53.99
Add to Cart
What is this?

Oracle PL/SQL Programming, Fifth Edition

Covers Versions Through Oracle Database 11g Release 2

By
Steven Feuerstein, Bill Pribyl
Publisher:
O'Reilly Media
Released:
September 2009
Pages:
1232

Product Editions

  1. Oracle PL/SQL Programming, Fifth Edition - September 2009
  2. Oracle PL/SQL Programming, Fourth Edition - August 2005
  3. Oracle PL/SQL Programming, Third Edition - September 2002 (out of print)
  4. Oracle PL/SQL Programming, Second Edition - September 1997 (out of print)
  5. Oracle PL/SQL Programming - September 1993 (out of print)
Description
The definitive reference on PL/SQL, Oracle PL/SQL Programming, Fifth Edition, covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete real applications, in the book and on the companion website. Ideal for novices and experienced Oracle programmers alike.
Full Description
Table of Contents

  1. Programming in PL/SQL

    1. Chapter 1 Introduction to PL/SQL

      1. What Is PL/SQL?
      2. The Origins of PL/SQL
      3. So This Is PL/SQL
      4. About PL/SQL Versions
      5. Resources for PL/SQL Developers
      6. Some Words of Advice

    2. Chapter 2 Creating and Running PL/SQL Code

      1. Navigating the Database
      2. Creating and Editing Source Code
      3. SQL*Plus
      4. Performing Essential PL/SQL Tasks
      5. Editing Environments for PL/SQL
      6. Calling PL/SQL from Other Languages

    3. Chapter 3 Language Fundamentals

      1. PL/SQL Block Structure
      2. The PL/SQL Character Set
      3. Identifiers
      4. Literals
      5. The Semicolon Delimiter
      6. Comments
      7. The PRAGMA Keyword
      8. Labels

  2. PL/SQL Program Structure

    1. Chapter 4 Conditional and Sequential Control

      1. IF Statements
      2. CASE Statements and Expressions
      3. The GOTO Statement
      4. The NULL Statement

    2. Chapter 5 Iterative Processing with Loops

      1. Loop Basics
      2. The Simple Loop
      3. The WHILE Loop
      4. The Numeric FOR Loop
      5. The Cursor FOR Loop
      6. Loop Labels
      7. The CONTINUE Statement
      8. Tips for Iterative Processing

    3. Chapter 6 Exception Handlers

      1. Exception-Handling Concepts and Terminology
      2. Defining Exceptions
      3. Raising Exceptions
      4. Handling Exceptions
      5. Building an Effective Error Management Architecture
      6. Making the Most of PL/SQL Error Management

  3. PL/SQL Program Data

    1. Chapter 7 Working with Program Data

      1. Naming Your Program Data
      2. Overview of PL/SQL Datatypes
      3. Declaring Program Data
      4. Programmer-Defined Subtypes
      5. Conversion Between Datatypes

    2. Chapter 8 Strings

      1. String Datatypes
      2. Working with Strings
      3. String Function Quick Reference

    3. Chapter 9 Numbers

      1. Numeric Datatypes
      2. Number Conversions
      3. Numeric Operators
      4. Numeric Functions

    4. Chapter 10 Dates and Timestamps

      1. Datetime Datatypes
      2. Getting the Current Date and Time
      3. Interval Datatypes
      4. Datetime Conversions
      5. Date and Timestamp Literals
      6. Interval Conversions
      7. Interval Literals
      8. CAST and EXTRACT
      9. Datetime Arithmetic
      10. Date/Time Function Quick Reference

    5. Chapter 11 Records

      1. Records in PL/SQL

    6. Chapter 12 Collections

      1. Collections Overview
      2. Collection Methods (Built-ins)
      3. Working with Collections
      4. Nested Table Multiset Operations
      5. Maintaining Schema-Level Collections

    7. Chapter 13 Miscellaneous Datatypes

      1. The BOOLEAN Datatype
      2. The RAW Datatype
      3. The UROWID and ROWID Datatypes
      4. The LOB Datatypes
      5. Working with LOBs
      6. Predefined Object Types

  4. SQL in PL/SQL

    1. Chapter 14 DML and Transaction Management

      1. DML in PL/SQL
      2. Transaction Management
      3. Autonomous Transactions

    2. Chapter 15 Data Retrieval

      1. Cursor Basics
      2. Working with Implicit Cursors
      3. Working with Explicit Cursors
      4. SELECT...FOR UPDATE
      5. Cursor Variables and REF CURSORs
      6. Cursor Expressions

    3. Chapter 16 Dynamic SQL and Dynamic PL/SQL

      1. NDS Statements
      2. Binding Variables
      3. Working with Objects and Collections
      4. Dynamic PL/SQL
      5. Recommendations for NDS
      6. When to Use DBMS_SQL
      7. Oracle Database 11g New Features

  5. PL/SQL Application Construction

    1. Chapter 17 Procedures, Functions, and Parameters

      1. Modular Code
      2. Procedures
      3. Functions
      4. Parameters
      5. Local or Nested Modules
      6. Module Overloading
      7. Forward Declarations
      8. Advanced Topics
      9. Go Forth and Modularize!

    2. Chapter 18 Packages

      1. Why Packages?
      2. Rules for Building Packages
      3. Rules for Calling Packaged Elements
      4. Working with Package Data
      5. When to Use Packages
      6. Packages and Object Types

    3. Chapter 19 Triggers

      1. DML Triggers
      2. DDL Triggers
      3. Database Event Triggers
      4. INSTEAD OF Triggers
      5. AFTER SUSPEND Triggers
      6. Maintaining Triggers

    4. Chapter 20 Managing PL/SQL Code

      1. Managing Code in the Database
      2. Managing Dependencies and Recompiling Code
      3. Compile-Time Warnings
      4. Testing PL/SQL Programs
      5. Tracing PL/SQL Execution
      6. Debugging PL/SQL Programs
      7. Protecting Stored Code
      8. Introduction to Edition-Based Redefinition (Oracle Database 11g Release 2)

    5. Chapter 21 Optimizing PL/SQL Performance

      1. Tools to Assist in Optimization
      2. The Optimizing Compiler
      3. Data Caching Techniques
      4. Bulk Processing for Multirow SQL
      5. Improving Performance With Pipelined Table Functions
      6. Specialized Optimization Techniques
      7. Stepping Back for the Big Picture on Performance

    6. Chapter 22 I/O and PL/SQL

      1. Displaying Information
      2. Reading and Writing Files
      3. Sending Email
      4. Working with Web-Based Data (HTTP)
      5. Other Types of I/O Available in PL/SQL

  6. Advanced PL/SQL Topics

    1. Chapter 23 Application Security and PL/SQL

      1. Security Overview
      2. Encryption
      3. Row-Level Security
      4. Application Contexts
      5. Fine-Grained Auditing

    2. Chapter 24 PL/SQL Architecture

      1. Who (or What) is DIANA?
      2. How Does Oracle Execute PL/SQL Code?
      3. The Default Packages of PL/SQL
      4. Execution Authority Models
      5. Conditional Compilation
      6. PL/SQL and Database Instance Memory
      7. Native Compilation
      8. What You Need to Know

    3. Chapter 25 Globalization and Localization in PL/SQL

      1. Overview and Terminology
      2. Unicode Primer
      3. Character Semantics
      4. String Sort Order
      5. Multilingual Information Retrieval
      6. Date/Time
      7. Currency Conversion
      8. Globalization Development Kit for PL/SQL

    4. Chapter 26 Object-Oriented Aspects of PL/SQL

      1. Introduction to Oracle’s Object Features
      2. Object Types by Example
      3. Object Views
      4. Maintaining Object Types and Object Views
      5. Concluding Thoughts from a (Mostly) Relational Developer

    5. Chapter 27 Calling Java from PL/SQL

      1. Oracle and Java
      2. Getting Ready to Use Java in Oracle
      3. A Simple Demonstration
      4. Using loadjava
      5. Using dropjava
      6. Managing Java in the Database
      7. Using DBMS_JAVA
      8. Publishing and Using Java in PL/SQL

    6. Chapter 28 External Procedures

      1. Introduction to External Procedures
      2. The Oracle Net Configuration
      3. Setting Up Multithreaded Mode
      4. Creating an Oracle Library
      5. Writing the Call Specification
      6. Raising an Exception from the Called C Program
      7. Nondefault Agents
      8. Maintaining External Procedures

  1. Appendix Regular Expression Metacharacters and Function Parameters

    1. Metacharacters

    2. Functions and Parameters

  2. Appendix Number Format Models

  3. Appendix Date Format Models

  4. Colophon

View Full Table of Contents
Product Details
Title:
Oracle PL/SQL Programming, Fifth Edition
By:
Steven Feuerstein, Bill Pribyl
Publisher:
O'Reilly Media
Formats:
  • Print
  • Ebook
  • Safari Books Online
Print Release:
September 2009
Ebook Release:
September 2009
Pages:
1232
Print ISBN:
978-0-596-51446-4
| ISBN 10:
0-596-51446-8
Ebook ISBN:
978-0-596-80632-3
| ISBN 10:
0-596-80632-9
Customer Reviews
About the Authors

  1. Steven Feuerstein

    Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly & Associates). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992.

    View Steven Feuerstein's full profile page.

  2. Bill Pribyl

    Bill Pribyl is the primary author of Learning Oracle PL/SQL and the coauthor of Oracle PL/SQL Programming and its companion pocket reference, all from O'Reilly Media. He is oddly proud of having used PL/SQL to write TCP/IP networking clients, tnsping callouts, near-realtime commodity price loaders, and transcendental functions. Bill, who holds a degree in physics from Rice University, is the former editor of the IOUG technical journal (Select) and former president of the South Central Oracle Users Group. At home with his family in Houston, Texas, Bill's current nonbillable titles include Webmaster for his neighborhood civic club, "IT Guy" for his son's Boy Scout troop, and Eucharistic Adoration Coordinator for his church. Visit Bill's firm at http://www.datacraft.com.

    View Bill Pribyl's full profile page.

Colophon
Ants are featured on the cover of Oracle PL/SQL Programming, Fifth Edition. At least 8,000 different species of ants can be found everywhere on Earth except the North and South Poles. Ants preserved in amber suggest that these insects existed 50 million years before humans.Humans have long been fascinated by ants, because these tiny insects are accomplished builders, nurses, miners, and even farmers. Fables such as "The Ant and the Grasshopper" extol the virtues of hardworking, forward-looking ants. (Hail ants!) It is true that individual ants are able to perform amazing feats: an ant can carry up to 50 times its body weight, can travel the human equivalent of 40 miles a day, and can climb vertical heights the equivalent of Mount Everest. However, the greatest accomplishments of ants are those performed together for the good of their community.Queen ants establish new communities, or nests, after their mating flight. On this flight the queen mates with several males. After mating, the males fall to Earth and die. The queen then finds an uninhabited nest, settles into it, and pulls her wings off. She will never fly again, and after removing her wings she is able to absorb the wing muscles as nutrients for her eggs. She will continue to lay eggs, thousands of them, for years.During the three-stage development process, which takes about two months, the eggs, larvae, and pupae are cared for by the nurse ants, who feed, clean, and carefully move the young to warmer or cooler places in the nest, depending on the temperature. These nurse ants are, in turn, cared for by other worker ants, who feed the nurses with regurgitated food. The workers and the nurses will fight together to defend the young against enemies if the nest is invaded, either by another group of ants or by a larger animal.
  • Book cover of Oracle PL/SQL Programming
Got a Question?
icons
Favicon Service and support by Satisfaction