Oracle PL/ SQL for dummies / by Michael Rosenblum and Paul Dorsey.

Format:

Book

Series:

--For dummies.

--For dummies

Language:

English

Subjects (All):

Oracle (Computer file).

Relational databases.

PL/SQL (Computer program language).

Physical Description:

1 online resource (435 p.)

Place of Publication:

Hoboken, N.J.: Wiley, c2006.

Summary:

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 toWrite efficient, easy-to-maintain codeTest and debug PL/SQL routinesIntegrate SQL and PL/SQLA

Contents:

Oracle PL/SQL For Dummies; About the Authors; Dedications; Authors' Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; Foolish Assumptions; How This Book Is Organized; Icons Used in This Book; Where to Go from Here; Part I: Basic PL/SQL Concepts; Chapter 1: PL/SQL and Your Database; Knowing Just Enough about Relational Databases; The Scoop on SQL and PL/SQL; What Is PL/SQL Good For?; 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 CodeEstablishing a Database Connection; The Basics of PL/SQL Programs; Examining the Sample Data; Part II: Getting Started with PL/SQL; Chapter 3: Laying the Groundwork: PL/SQL Fundamentals; PL/SQL As a Programming Language; Anonymous PL/SQL Blocks; Introducing the Lexical Set of Elements; Working with Constants and Variables; Building Expressions with Operators; Running Anonymous Blocks of Code; Creating Reusable PL/SQL Code; Storing PL/SQL in the Database; Checking Out PL/SQL Extras; Chapter 4: Controlling Program Flow; Creating Condition Statements; Looping the Loop

Chapter 5: Handling ExceptionsUnderstanding Exception Basics; Adding Exception Handlers to Your Code; Understanding Different Exception Types; Predefined Exceptions in PL/SQL Code; Adding User-Defined Exceptions; Propagation of Exceptions; Writing Exceptional Exceptions; Chapter 6: PL/SQL and SQL Working Together; Cursors: What They Are and How to Use Them; Knowing Where to Declare Cursors; Being Explicitly Smart with Implicit Cursors; Accessing Status Info by Using Cursor Variables; Updating Records Fetched from Cursors; Taking a Shortcut with CURSOR FOR Loops; Referencing Functions in SQL

Part III: Standards and StructuresChapter 7: Putting Your Code in the Right Place; Putting Code in the Database; Putting Code in the Application Server (Middle-Tier Approach); Where Should You Place the Business Logic?; Chapter 8: Creating Naming Standards; What's in a Naming Standard?; Setting Naming Standards for Common Code Elements; Making Sure Your Organization Follows Standards; Chapter 9: Creating Coding Standards; Why Standards Are Important; Universal Truths; Developing SQL Code Consistently; Part IV: PL/SQL Data Manipulations; Chapter 10: Basic Datatypes

Introducing the Main Datatype GroupsWorking with Numeric Datatypes; Keeping Track of Date and Time; Storing Logical Values with BOOLEAN; Processing Characters and Strings; Chapter 11: Advanced Datatypes; Handling Large Objects in the Database; Working with Large Objects; Keeping Code Consistent with User-Defined Subtypes; Defining Your Own Datatypes; Grouping Sets of Data into Collections; Speeding Up Data Collection with Bulk Operations; Part V: Taking PL/SQL to the Next Level; Chapter 12: Transaction Control; Using Transactions to Maintain Data Consistency

Committing or Rolling Back Changes to the Database

Notes:

Includes index

ISBN:

1-118-05479-2

0-470-05413-1

OCLC:

82145792