(Ebook) Oracle PL SQL for Dummies 1st Edition by Michael Rosenblum, Dr Paul Dorsey ISBN 1118054792 9780764599576

(Ebook) Oracle PL SQL for Dummies 1st Edition by Michael Rosenblum, Dr Paul Dorsey ISBN 1118054792 9780764599576

(Ebook) Oracle PL SQL for Dummies 1st Edition by Michael Rosenblum, Dr Paul Dorsey - Ebook PDF Instant Download/Delivery: 1118054792 ,9780764599576
Full download (Ebook) Oracle PL SQL for Dummies 1st Edition after payment

Product details:
ISBN 10: 1118054792
ISBN 13: 9780764599576
Author: Michael Rosenblum, Dr Paul Dorsey

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

(Ebook) Oracle PL SQL for Dummies 1st Edition Table of contents:

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 Code

Establishing 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 Exceptions

Understanding 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 Structures

Chapter 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 Groups

Working 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

Autonomous Transactions

Chapter 13: Dynamic SQL and PL/SQL

Taking Advantage of Dynamic SQL

A Simple EXECUTE IMMEDIATE

Building SQL on the Fly

Building DDL on the Fly

Using Quoted Strings with Dynamic SQL

Working with Advanced Datatypes

Chapter 14: PL/SQL Best Practices

Why Are Best Practices Important?

Laying the Groundwork for Good Coding

Writing Code with Best Practices in Mind

Testing Your Code

Coding the Agile Way

Keeping Up-to-Date with Oracle

Part VI: The Part of Tens

Chapter 15: Ten PL/SQL Tips

Use SELECT INTO Correctly

Don’t Assume Column Order in DML Statements

Use the NOCOPY Command

Be Careful of Function Calls That Impact Performance

Beware of Implicit Commits

Use Only One RETURN Statement per Function

Save Debugging Time with WHEN OTHERS

Know When to Pass Parameters or Use Global Variables

Use Implicit Cursors When Appropriate

Remember That Dates Are Numbers

Chapter 16: Ten Common Mistakes to Avoid in PL/SQL

Catching an Exception with WHEN OTHERS THEN NULL

Forgetting to Handle NULL Values

Creating Unintended Boolean Expressions

Forgetting to Close an Explicit Cursor

Starting Endless Loops

Reinventing the Wheel

Converting Datatypes Implicitly

Cutting and Pasting Code

Ignoring Code Readability

Assuming Code Doesn’t Need Comments

People also search for (Ebook) Oracle PL SQL for Dummies 1st Edition:

    
oracle pl sql quiz
    
oracle pl/sql' quoted string
    
oracle pl sql query
    
oracle pl sql query with parameters
    
oracle pl sql interview questions and answers

Tags: Michael Rosenblum, Dr Paul Dorsey, Oracle, PL SQL