Vous voulez voir cette page en français ? Cliquez ici.

Sign in to turn on 1-Click ordering.
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Learning Oracle PL/SQL [Paperback]

Bill Pribyl , Steven Feuerstein
4.1 out of 5 stars  See all reviews (12 customer reviews)
List Price: CDN$ 49.99
Price: CDN$ 49.88 & FREE Shipping. Details
You Save: CDN$ 0.11
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.ca. Gift-wrap available.
Want it delivered Friday, October 24? Choose One-Day Shipping at checkout.
Join Amazon Student in Canada

Book Description

Dec 1 2001 0596001800 978-0596001803 1

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?
  • 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.

Special Offers and Product Promotions

  • Join Amazon Student in Canada

Customers Who Bought This Item Also Bought

Product Details

Product Description


No doubt that reading this book and applying its principles will make the reader a better PL/SQL programmer. -- Ileana Bâlcu, New York Oracle Users Group, March 2002

From the Publisher

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 Oracle9i, includes sample programs downloadable from examples.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

Most helpful customer reviews
4.0 out of 5 stars Overall very good July 15 2003
By cyli
I've only read three chapters so far. It's been very good actually - I knew some SQL beforehand, although nothing very complicated, and it has been pretty easy for me to understand as well as very helpful for me in learning how to use PL/SQL. It has genuinely useful examples, and also provides tips as to how to perform unit testing on stored procedures and functions.
Another very useful thing the author does is list common and not-as-common mistakes that a programmer may make (which may not always result in errors or exceptions), hence possibly saving you the trouble of hours of debugging.
The only problem I've had with it is that he doesn't treat foreign keys as constraints. One of his sample column declarations is: "isbn VARCHAR2(100) FOREIGN KEY REFERENCES books (isbn)", but I kept getting an error until I changed it to: "isbn VARCHAR2(100), FOREIGN KEY (isbn) REFERENCES books (isbn)". I am not sure if this is a peculiarity of my installation (running Oracle 9i), but a check online reveals that many people also consider foreign keys a constraint.
Except for that problem, I would have given this book 5 stars.
Was this review helpful to you?
5.0 out of 5 stars Wonderful intro to PL/SQL Feb. 10 2002
By A Customer
A book doesn't have to cover advanced material and tricks from gurus to be great. There are only a handful of really good Oracle books, and this is one. It takes the beginner through the important features of PL/SQL, and uses an example application that you build as you go along.
The organization is great and the writing is crystal clear. It doesn't just cover syntax. It also explains when and why you'd want to use various PL/SQL features.
If you're a radical C++ coding genius, maybe you want one of the other O'Reilly books on PL/SQL. On the other hand, if you've tried some other books that deal with PL/SQL and found they didn't provide the background, explanations and programming strategies you need, try this book. The authors are talented PL/SQL experts, and their presentation of the subject is great.
This book is not a slap-dash effort to write a quick book. It's a solid, quality book. If you have some exposure to Oracle but have never developed PL/SQL skills, you'll like this book.
Was this review helpful to you?
4.0 out of 5 stars One of the best intros to PL/SQL March 12 2002
Learning Oracle PL/SQL is one of the best books I have read on learning this subject. This book has a little for everyone: you'll learn something if you know the basics of SQL, but have never really done anything with it. You'll also learn something if you've had a lot of experience with Microsoft SQLServer (and T-SQL), but are looking to transition you knowledge to Oracle PL/SQL.
You'll learn about coding anonymous blocks, stored procedures, functions, and packages. You will learn how to write and use cursors, how to organize code into packages, Oracle security basics, Oracle built in packages, and error handling. The book also covers some basics of using SQL*Plus, to make your life a little easier.
If you need a relatively small (less than 400 pages) introduction to Oracle PL/SQL, then this is definitely a book you will want to pick up. If you need more in-depth information after reading this book, pick up the authors' other book Oracle PL/SQL.
Was this review helpful to you?
5.0 out of 5 stars I recommend this book Oct. 12 2002
Listen Software Solutions: PL/SQL introduces a new dimension of power programming capability for the developer. The goal of reusable code measurely improves quality verse vast amounts of non-reusable SQL. PL/SQL packages describe function and procedure specification and body. The specification describes the package interface to the calling application. The package specification approach is part of good design. The package specification exposes procedures and their parameter properties to external applications. Each specification has a package body. Within the package body various data structures, such as arrays and tables can be referenced, functions called, and procedures executed. Developers new to PL/SQL often understand insert, update, and delete data manipulations; but are confused about selection. This is because they don't know about cursors.
I recommend this book. As a developer having knowledge resource information is critical.
Was this review helpful to you?
1.0 out of 5 stars Learning Oracle Maybe, But Not PL/SQL Sept. 13 2003
I've been developing with Sybase and SQL Server for about 5 years with very limited experience with Oracle in that time. I purchased this book hoping to get up to speed on the differences between Oracle's PL/SQL and the Sybase/Microsoft T-SQL syntax. From the title this book seemed appropriate for the job. In short, while the book might be an adequate, albeit SLOW, introduction to Oracle, it covers very little actual PL/SQL.
If you are a programer/engineer/dba looking to "learn Oracle PL/SQL", interested in practical applications of such fundamental topics as constraints, foreign keys, indexes, joins, cursors, views, triggers, corelated subqueries and the like, look elsewhere. Don't take my word for it--take a peek at the index or table of contents and you'll see that the focus of this book has very little to do with PL/SQL.
Was this review helpful to you?
5.0 out of 5 stars Recommended Nov. 27 2002
By A Customer
I've been a self taught Oracle PL/SQL developer for two years, so I was sceptical on reading a "Learning" book. After reading the first few chapters I was able to make improvements to my PL/SQL programs. It was definitely worth the time and money. The examples are well written and simple enough to make sense, but not too simple that they are "duh" type examples. I also liked the fact that the book explains how to set up and use Oracle/Apache to make PSP pages (Stored Procedures that generate web content). The PSP section makes up a good portion of the book that I didn't know was in it before I got it. With plenty of real-world experience tips, a section on tools and security, it will be a while before I have this ingrained and used on a daily basis. I defiantly got more than I was looking for.
Was this review helpful to you?
Want to see more reviews on this item?
Most recent customer reviews
Search Customer Reviews
Only search this product's reviews

Look for similar items by category