Oracle PL/SQL 101 (Paperback)

by Christopher Allen (Author) "Welcome to the wonderful world of databases..." (more)
Key Phrases: medium wodget, chrome phoobar, chrome snaphoo, Round Snaphoo, Shipping Carton, Red Snaphoo (more...)

Editorial Reviews

Product Description
This in-depth guide explains how to use SQL to work with data in a database, and how to automate complicated tasks using PL/SQL.

From the Author
Not too long ago my lovely wife decided she wanted to learn more about SQL and Oracle. I thought that was a great idea, so I gave her the 3 or 4 books I had on SQL and PL/SQL, and we bought 2 or 3 more as time went on. By this time we had just about every major SQL book on the market. In the months that followed we both came to the conclusion that while the books contained lots of information, none of them seemed to be written for a beginner. Many assumed prior knowledge of SQL, Oracle, or a programming language like C++. They offered plenty of examples producing results that had no particular value, and many of the books jumped around from topic to topic without bringing everything together into a bigger picture that relates to normal work life.

What I present here is my best effort at explaining SQL and PL/SQL in a way that makes sense. I have worked to create examples that demonstrate not only how to use each feature, but also why. I’ve provided exercises that mirror the kinds of tasks you’ll be asked to accomplish if you make SQL and PL/SQL part of your work. And I’ve done my best to make the writing reasonably interesting to read, so your flame of interest in this fascinating topic stays burning.

All the best in your SQL endeavors,
Christopher Allen

See all Editorial Reviews

Product Details

• Paperback: 420 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (December 1, 2000)
• Language: English
• ISBN-10: 007212606X
• ISBN-13: 978-0072126068
• Product Dimensions: 8.8 x 7.1 x 1.2 inches
• Shipping Weight: 1.6 pounds
• Average Customer Review: 4.4 out of 5 stars See all reviews (79 customer reviews)
• Amazon.com Sales Rank: #124,948 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #18 in	Books > Computers & Internet > Databases > Oracle > PL & SQL
  #42 in	Books > Computers & Internet > Certification Central > Publisher > Osborne-McGraw-Hill
  #54 in	Books > Computers & Internet > Databases > Relational Databases

Customer Reviews

Most Helpful Customer Reviews

13 of 13 people found the following review helpful:

5.0 out of 5 stars A perfect book for a newcomer to PL/SQL, January 23, 2001

By	"mhasnain" (Denver, Colorado) - See all my reviews

I enjoyed reading the PL/SQL 101 thoroughly, I have finished one complete reading of the book and now I am going through it the second time. I decided to buy this book after getting totally frustrated of asking others to help me with Oracle. I asked our dedicated Oracle DBA to show me how to create a simple table, it took me more than three months to chase her and could not get any result and one day I found out she was gone, then I bought the PL/SQL 101 and in chapter one the author explains the most basic way to get going.

Remember this is a 101 book, if you already know quite a bit of SQL, then this book might bore you. The title is perfect, and its readers should of that level.

I would like to thank the author for getting me hooked to Oracle and PL/SQL the easy way (Ofcourse there is no easy way, you still have to read and reread the book several times, and practice and practice).

10 of 10 people found the following review helpful:

5.0 out of 5 stars Perfect introduction to Oracle PL/SQL, October 11, 2001

By	Ron Truman (Chicago, IL) - See all my reviews

It's right there on the cover: Oracle PL/SQL. And that's what this book explains, from the very beginning. You can't learn PL/SQL without knowing SQL, so a substantial portion of the book covers SQL techniques that are necessary to write good PL/SQL code.

Each chapter has dozens of exercises, so by the end of the book you have worked through hundreds of experiments, samples, and exercises. It's all hands-on.

The sections on PL/SQL programming cover functions, procedures, packages, and triggers...all the tools you need to make Oracle dance to your tune.

9 of 9 people found the following review helpful:

5.0 out of 5 stars Excellent place to start for PL/SQL, September 5, 2001

By	P. Heath (Hurst, TX United States) - See all my reviews (TOP 500 REVIEWER)    (REAL NAME)

This is one of the best books that I've bought recently. I've been a programmer for 4 years, but I just recently started working with relational databases, specifically Oracle. This book is clear, concise, and very accessible. The writing style is very engaging, too. The author manages to present the material in a way that keeps your interest without sacraficing quality. Consequently, the book is fast to read, but of great value.

The chapter on using SQL*Plus is of great value. It helped me to more effective look at what is in our databases to get a feel for the results from the programs that I was testing.

After reading this book I felt like the author gave a solid overview of the PL/SQL language without being overly rigorous. If you are looking for an academic treatment with lots of theory, this is not the place. Those books are very import to broaden your understanding, but this book bridges the gap to make the advance texts accessible.

This is the place for Oracle beginners to get their hands dirty. There are plenty of examples that run throughout the book to demonstrate the concepts. As you work with PL/SQL and SQL*Plus, you will find yourself referring back to this book often as you come up to speed. It is definitely worth the money and the time.