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

出版时间：2006-6  出版社：John Wiley & Sons Inc  作者：Rosenblum, Michael/ Dorsey, Paul, Dr./ Dorsey, Paul  页数：414  
Tag标签：无  

内容概要

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. 作者简介：    Michael Rosenblum is originally from Kremenchuk, Ukraine. In 2000, he moved to the United States, where he lives with his family in Edison, New Jersey. He works as a Development DBA at Dulcian, Inc. Michael is responsible for system tuning and application architecture. He also supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is a frequent presenter at various regional and national Oracle user group conferences.    In his native Ukraine, he received the scholarship of the President of Ukraine, a Masters Degree in Information Systems, and a Diploma with Honors from the Kiev National University of Economics, Ukraine.

书籍目录

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.