1 1
£18.68 GBP
£18.68 GBP
Sale Sold out
Free UK Shipping

Freshly Printed - allow 7 days lead

Oracle PL / SQL For Dummies

Michael Rosenblum (Author), Paul Dorsey (Author)

9780764599576, Wiley

Paperback / softback, published 6 June 2006

432 pages
23.1 x 18.3 x 2.3 cm, 0.771 kg

Find tips for creating efficient PL/SQL code

If you know a bit about SQL, this book will make PL/SQL programming painless!

The Oracle has spoken—you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book! You'll find out about code structures, best practices, and code naming standards, how to use conditions and loops, where to place PL/SQL code in system projects, ways to manipulate data, and more.

Discover how to

  • Write efficient, easy-to-maintain code
  • Test and debug PL/SQL routines
  • Integrate SQL and PL/SQL
  • Apply PL/SQL best practices
  • Use new features introduced in Oracle 9i and 10g

Introduction.

Part I: Basic PL/SQL Concepts.

Chapter 1: PL/SQL and Your Database.

Chapter 2: The PL/SQL Environment.

Part II: Getting Started with PL/SQL.

Chapter 3: Laying the Groundwork: PL/SQL Fundamentals.

Chapter 4: Controlling Program Flow.

Chapter 5: Handling Exceptions.

Chapter 6: PL/SQL and SQL Working Together.

Part III: Standards and Structures.

Chapter 7: Putting Your Code in the Right Place.

Chapter 8: Creating Naming Standards.

Chapter 9: Creating Coding Standards.

Part IV: PL/SQL Data Manipulations.

Chapter 10: Basic Datatypes.

Chapter 11: Advanced Datatypes.

Part V: Taking PL/SQL to the Next Level.

Chapter 12: Transaction Control.

Chapter 13: Dynamic SQL and PL/SQL.

Chapter 14: PL/SQL Best Practices.

Part VI: The Part of Tens.

Chapter 15: Ten PL/SQL Tips.

Chapter 16: Ten Common Mistakes to Avoid in PL/SQL.

Index.

Subject Areas: Computer programming / software development [UM]
View full details