SQL - Learning Oracle PL-SQL.pdf - Dokumenty - szamo8

Database > Learning Oracle PL/SQL

Learning Oracle PL/SQL

Bill Pribyl

Steven Feuerstein

Publisher: O'Reilly

First Edition December 2001

ISBN: 0-596-00180-0, 424 pages

Summary

Table of Contents

Index

Examples

Errata

The Editor's Website

Designed for both new programmers and those experienced in

other languages, this book presents the core features of

Oracle's PL/SQL language in an easy-to-read format. Learning

Oracle PL/SQL will bring programmers up to speed on the

most important aspects of PL/SQL, including web and Internet

programming. Updated through Oracle 9i, includes sample

programs downloadable from http://oracle.oreilly.com .

About the Authors

Full Description

Reviews

Reader reviews

Colophon

Full Description

PL/SQL, Oracle's programming language for stored

procedures, delivers a world of possibilities for your database

programs. PL/SQL supplements the standard relational

database language, SQL, with a wide range of procedural

features, including loops, IF-THEN statements, advanced data

structures, and rich transactional control--all closely integrated

with the Oracle database server.

Knowing where to start with Oracle's procedural language is

not always obvious to a newcomer, especially considering the

language's feature set and the sheer size of the official

documentation (not to mention Oracle's ever-increasing

number of pre-built PL/SQL programs). But Learning Oracle

PL/SQL offers the signposts and guidance you need to come

up to speed on the language, delivered in a manageable

number of pages while covering all the essentials.

Topics include:

PL/SQL--what is it, and why use it? Why use PL/SQL

instead of Java?

file:///E|/O'Reilly/O'Reilly%20-%20Learning%20Oracle%20PLSQL/default.html (1 of 4) [15/05/2002 22:43:01]

Syntax and examples of all core language constructs

Creating, using, and reusing stored procedures,

functions, and packages

Building web-based applications using PL/SQL features

available "out of the box" (such as PL/SQL Server

Pages)

Securing PL/SQL programs against attack

Benefits of third-party developer tools and integrated

development environments

Connecting PL/SQL to email, Java, and the Internet

Meticulously crafted with all-new examples downloadable from

examples.oreilly.com/learnoracle , the book addresses

language features available in all versions of Oracle, from

Oracle7 to Oracle8i to Oracle9i.

Learning Oracle PL/SQL was written by PL/SQL experts Bill

Pribyl and Steven Feuerstein, whose easy-to-read style and

attention to detail has made other O'Reilly books (such as the

bestselling Oracle PL/SQL Programming ) very popular among

Oracle developers worldwide. Learning Oracle PL/SQL is

meant for a wide range of target audiences, including both

beginning programmers and those already experienced with

other programming languages. Whether you are a new

developer, a crossover programmer from another database

system, or a new database administrator who needs to learn

PL/SQL, this book will get you well on your way. It is the perfect

introduction to Oracle PL/SQL Programming , also by Pribyl and

Feuerstein.

About the Authors

Bill Pribyl Bio to be posted soon

Steven Feuerstein is considered one of the world's leading

experts on the Oracle PL/SQL language. He is the author or

coauthor of six books on PL/SQL, including the now-classic

Oracle PL/SQL Programming and Oracle PL/SQL Best

Practices , all from O'Reilly & Associates. Steven is a Senior

Technology Advisor with Quest Software, has been developing

software since 1980, and worked for Oracle Corporation from

1987 to 1992. Steven is president of the Board of Directors of

the Crossroads Fund , which makes grants to Chicagoland

organizations working for social, racial and economic justice.

file:///E|/O'Reilly/O'Reilly%20-%20Learning%20Oracle%20PLSQL/default.html (2 of 4) [15/05/2002 22:43:01]

You can reach Steven at steven@stevenfeuerstein.com.

Reviews

"As someone who knows C, Perl, and Java, I found this to be a

great starter book in PL/SQL. It gave me the core knowledge I

needed for a jump-start into PL/SQL programming. This is a

great book for anybody wanting to learn PL/SQL programming

for Oracle!"

--Bill Phillips, System Engineer, Diverse Networks

"As a project manager for an IT consulting firm, I needed to go

beyond basic SQL and leverage the efficiency and versatility of

PL/SQL. After searching in vain for an introduction to PL/SQL

that required no prior programming experience, I've finally

found a book that is truly for the beginner. This book provides

thorough explanations of the sample code in plain English,

written so that I can understand why the programs work. It's the

next best thing to sitting down with someone for a private

tutorial."

--Corrie Nettles, former consultant at Baker Robbins & Co., and

Oracle Certified Professional in database administration

Readers Reviews

December 06, 2001 Rating:

No one can write PL/SQL better than Steven Feuerstein. If you

can not understand/program PL/SQL after reading this book

you can consider a carrier change. Highly recommended for

anyone who is interested in learning Oracle Programming .

K Gopalakrishnan

reserved.

Printed in the United States of America.

file:///E|/O'Reilly/O'Reilly%20-%20Learning%20Oracle%20PLSQL/default.html (3 of 4) [15/05/2002 22:43:01]

Published by O'Reilly & Associates, Inc., 1005 Gravenstein

Highway North, Sebastopol, CA 95472.

O'Reilly & Associates books may be purchased for educational,

business, or sales promotional use. Online editions are also

available for most titles ( http://safari.oreilly.com ). For more

information contact our corporate/institutional sales

department: 800-998-9938 or corporate@oreilly.com .

The O'Reilly logo is a registered trademark of O'Reilly &

Associates, Inc. Many of the designations used by

manufacturers and sellers to distinguish their products are

claimed as trademarks. Where those designations appear in

this book, and O'Reilly & Associates, Inc. was aware of a

trademark claim, the designations have been printed in caps or

initial caps.

While every precaution has been taken in the preparation of

this book, the publisher assumes no responsibility for errors or

omissions, or for damages resulting from the use of the

information contained herein.

Last updated on 12/4/2001

Brought to you by KnowledgeLiberation

file:///E|/O'Reilly/O'Reilly%20-%20Learning%20Oracle%20PLSQL/default.html (4 of 4) [15/05/2002 22:43:01]

Database > Learning Oracle PL/SQL

Learning Oracle PL/SQL - Index

Dedication

Preface

Is This Book for You?

Other Books in This Series

Why This Book?

Which Oracle and PL/SQL Versions?

Organization of This Book

Conventions Used in This Book

Comments and Questions

Acknowledgments

1. PL/SQL: What, When, and Where

1.1 What Is PL/SQL?

1.2 Why Use PL/SQL?

1.3 What You Need to Get Started with PL/SQL

2. Fundamentals

2.1 PL/Lingo

2.2 Running Your First PL/SQL Program

2.3 Introduction to Program Structure

2.4 Variables

2.5 Common Operators

2.6 Conditional Logic

2.7 Executing in Circles: Loop Statements

2.8 Code Formatting: Requirements and Guidelines

2.9 Some Advanced Fundamentals

3. Let's Code!

3.1 Some Background on the Example

3.2 A First Programming Exercise

3.3 Retrieving a Book Count with a Function

3.4 Make Your Code Resilient

3.5 Using PL/SQL Packages to Organize Code

3.6 Going to the Next Level

3.7 Now What?

4. Go Web, Young Man

4.1 Introduction to HTML

4.2 Using PL/SQL to Create Web Pages

4.3 What Else?

5. Fetch!

file:///E|/O'Reilly/O'Reilly%20-%20Learning%20Oracle%20PLSQL/toc.html (1 of 2) [15/05/2002 22:44:24]

SQL - Learning Oracle PL-SQL.pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: