Skip to main content
  • Book
  • © 2011

Expert PL/SQL Practices

for Oracle Developers and DBAs

Apress
  • Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the best and the brightest in the field.

Buy it now

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (15 chapters)

  1. Front Matter

    Pages i-xxii
  2. Do Not Use

    • Riyaj Shamsudeen
    Pages 1-18
  3. Dynamic SQL: Handling the Unknown

    • Michael Rosenblum
    Pages 19-43
  4. PL/SQL and Parallel Processing

    • Dominic Delmolino
    Pages 45-70
  5. Warnings and Conditional Compilation

    • Torben Holm
    Pages 71-96
  6. PL/SQL Unit Testing

    • Sue Harper
    Pages 97-120
  7. Bulk SQL Operations

    • Connor McDonald
    Pages 121-169
  8. Know Your Code

    • Lewis Cunningham
    Pages 171-212
  9. Contract-Oriented Programming

    • John Beresniewicz
    Pages 213-233
  10. PL/SQL from SQL

    • Adrian Billington
    Pages 235-289
  11. Choosing the Right Cursor

    • Melanie Caffrey
    Pages 291-312
  12. PL/SQL Programming in the Large

    • Martin Büchi
    Pages 313-366
  13. Evolutionary Data Modeling

    • Robyn Sands
    Pages 367-394
  14. Profiling for Performance

    • Ron Crisco
    Pages 395-423
  15. Coding Conventions and Error Handling

    • Stephan Petit
    Pages 425-443
  16. Dependencies and Invalidations

    • Arup Nanda
    Pages 445-474
  17. Back Matter

    Pages 475-490

About this book

Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or feature set that you’ll face as a PL/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can make a positive difference in the quality and scalability of code that you write.

The path to mastery begins with syntax and the mechanics of writing statements to make things happen. If you’ve reached that point with PL/SQL, then let the authors of Expert PL/SQL Practices show you how to combine syntax and mechanics with features and techniques to really make the language sing. You’ll learn to do more with less effort, to write code that scales and performs well, and to eliminate and avoid defects.

These authors are passionate about PL/SQL and the power it places at your disposal. They want you to succeed, to know all that PL/SQL can offer. Let Expert PL/SQL Practices open your eyes to the full power of Oracle’s world-class language for the database engine.

  • Goes beyond the manual to cover good techniques and best practices
  • Delivers knowledge usually gained only by hard experience
  • Covers the functionality that distinguishes PL/SQL as a powerful and scalable programming language for deploying logic inside the database engine

About the authors

Michael Rosenblum is a Software Architect/Development DBA at Dulcian, Inc. where he is responsible for system tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is the co-author of PL/SQL for Dummies (Wiley Press, 2006) and author of a number of database-related articles (IOUG Select Journal, ODTUG Tech Journal). Michael is an Oracle ACE, a frequent presenter at various regional and national Oracle user group conferences (Oracle OpenWorld, ODTUG, IOUG Collaborate, RMOUG, NYOUG, etc), and winner of the ODTUG Kaleidoscope 2009 Best Speaker Award. In his native Ukraine, he received the scholarship of the President of Ukraine, a Master of Science degree in Information Systems, and a diploma with honors from the Kiev National University of Economics.

Bibliographic Information

  • Book Title: Expert PL/SQL Practices

  • Book Subtitle: for Oracle Developers and DBAs

  • Authors: John Beresniewicz, Adrian Billington, Martin Büchi, Melanie Caffrey, Ron Crisco, Lewis Cunningham, Dominic Delmolino, Sue Harper, Torben Holm, Connor McDonald, Arup Nanda, Stephan Petit, Michael Rosenblum, Robyn Sands, Riyaj Shamsudeen

  • DOI: https://doi.org/10.1007/978-1-4302-3486-9

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books

  • Copyright Information: The Author(s) 2011

  • Softcover ISBN: 978-1-4302-3485-2Published: 26 July 2011

  • eBook ISBN: 978-1-4302-3486-9Published: 10 December 2011

  • Edition Number: 1

  • Number of Pages: XXII, 512

  • Topics: Database Management, Programming Languages, Compilers, Interpreters

Buy it now

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access