Oracle PL/SQL for dummies
Author(s)
Bibliographic Information
Oracle PL/SQL for dummies
(--For dummies)
Wiley, c2006
Access to Electronic Resource 1 items
-
-
Oracle PL/
c2006.
-
Oracle PL/
Available at / 1 libraries
-
No Libraries matched.
- Remove all filters.
Note
Includes index
Description and Table of Contents
Description
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
Table of Contents
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.
by "Nielsen BookData"