Oracle PL/SQL For Dummies
Samenvatting
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
Specificaties
Inhoudsopgave
<p>Part I: Basic PL/SQL Concepts.</p>
<p>Chapter 1: PL/SQL and Your Database.</p>
<p>Chapter 2: The PL/SQL Environment.</p>
<p>Part II: Getting Started with PL/SQL.</p>
<p>Chapter 3: Laying the Groundwork: PL/SQL Fundamentals.</p>
<p>Chapter 4: Controlling Program Flow.</p>
<p>Chapter 5: Handling Exceptions.</p>
<p>Chapter 6: PL/SQL and SQL Working Together.</p>
<p>Part III: Standards and Structures.</p>
<p>Chapter 7: Putting Your Code in the Right Place.</p>
<p>Chapter 8: Creating Naming Standards.</p>
<p>Chapter 9: Creating Coding Standards.</p>
<p>Part IV: PL/SQL Data Manipulations.</p>
<p>Chapter 10: Basic Datatypes.</p>
<p>Chapter 11: Advanced Datatypes.</p>
<p>Part V: Taking PL/SQL to the Next Level.</p>
<p>Chapter 12: Transaction Control.</p>
<p>Chapter 13: Dynamic SQL and PL/SQL.</p>
<p>Chapter 14: PL/SQL Best Practices.</p>
<p>Part VI: The Part of Tens.</p>
<p>Chapter 15: Ten PL/SQL Tips.</p>
<p>Chapter 16: Ten Common Mistakes to Avoid in PL/SQL.</p>
<p>Index.</p>