Oracle PL/SQL 手册 Oracle PL/SQL For Dummies

书籍目录

Introduction  About This Book  Foolish Assumptions  How This Book Is Organized    Part Ⅰ: Basic PL/SQL Concepts    Part Ⅱ: Getting Started with PL/SQL    Part Ⅲ: Standards and Structures    Part Ⅳ: PL/SQL Data Manipulations    Part Ⅴ: Taking PL/SQL to the Next Level    Part Ⅵ: The Part of Tens,  Icons Used in This Book  Where to Go from HerePart Ⅰ: Basic PL/SQL Concepts,  Chapter 1: PL/SQL and Your Database    Knowing Just Enough about Relational Databases      What makes a database "relational"?      Understanding basic database terminology      Introducing database normalization      What is a DBMS?    The Scoop on SQL and PL/SQL      The purpose of SQL and PL/SQL      The difference between SQL and PL/SQL      What's new in Oracle SQL and PL/SQL?    What Is PL/SQL Good For?      Using database triggers      Scripting with speed      Keeping code server-side      Programming for Oracle Developer  Chapter 2: The PL/SQL Environment    Setting Up an Oracle Environment    Hardware and Software Requirements    Accessing the Oracle Technology Network    Installing the Database    Working with Code      SQL*Plus      Oracle SQL Developer      Third-party tools    …… Part Ⅱ: 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 Ⅲ: Standards and Structures.   Chapter 7: Putting Your Code in the Right Place.   Chapter 8: Creating Naming Standards.   Chapter 9: Creating Coding Standards. Part Ⅳ: PL/SQL Data Manipulations.   Chapter 10: Basic Datatypes.   Chapter 11: Advanced Datatypes. Part Ⅴ: 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 Ⅵ: The Part of Tens.   Chapter 15: Ten PL/SQL Tips.   Chapter 16: Ten Common Mistakes to Avoid in PL/SQL. Index.

作者简介

在线阅读本书



  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

 Oracle PL/SQL 手册 Oracle PL/SQL For Dummies下载