Beschreibung:
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
Find tips for creating efficient PL/SQL codeIf you know a bit about SQL, this book will make PL/SQLprogramming painless!The Oracle has spoken--you need to get up to speed onPL/SQL programming, right? We predict it'll be a breeze with thisbook! You'll find out about code structures, best practices, andcode naming standards, how to use conditions and loops, where toplace PL/SQL code in system projects, ways to manipulate data, andmore.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.