Buy New

or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
Buy Used
Used - Acceptable See details
$4.85 & eligible for FREE Super Saver Shipping on orders over $25. Details

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
Have one to sell? Sell yours here
Sams Teach Yourself PL/SQL in 21 Days (2nd Edition)
 
See larger image
 
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.

Sams Teach Yourself PL/SQL in 21 Days (2nd Edition) [Paperback]

Jonathan Gennick (Author), Tom Luers (Author)
2.9 out of 5 stars  See all reviews (10 customer reviews)

List Price: $39.99
Price: $26.39 & this item ships for FREE with Super Saver Shipping. Details
You Save: $13.60 (34%)
  Special Offers Available
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
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Only 6 left in stock--order soon (more on the way).
Want it delivered Monday, January 30? Choose One-Day Shipping at checkout. Details
Textbook Student FREE Two-Day Shipping for Students. Learn more

Formats

Amazon Price New from Used from
Paperback $26.39  

Book Description

0672317982 978-0672317989 January 1, 2000 2

Sams Teach Yourself PL/SQL in 21 Days, Second Edition, quickly empowers you to create your own Oracle solutions with PL/SQL. Completely revised to cover Oracles 8i, the book provides guidance and direction, leading you through a progression of topics that begin with the basic building blocks of PL/SQL, and ending with in-depth discussions of the more commonly used advanced features of Oracle's database programming environment. New topics include extended dynamic SQL within PL/SQL, Dynamic SQL within PL/SQL, use of invoker's rights, autonomous transactions, interfacing PL/SQL with Java, PL/SQL Bulk Binds, parameter passing by reference, and advanced Querying.


Special Offers and Product Promotions

  • Buy $50 in qualifying physical textbooks, get $5 in Amazon MP3 Credit. Here's how (restrictions apply)

Frequently Bought Together

Customers buy this book with Toad Pocket Reference for Oracle (Pocket Reference (O'Reilly)) $9.95

Sams Teach Yourself PL/SQL in 21 Days (2nd Edition) + Toad Pocket Reference for Oracle (Pocket Reference (O'Reilly))
  • This item: Sams Teach Yourself PL/SQL in 21 Days (2nd Edition)

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Toad Pocket Reference for Oracle (Pocket Reference (O'Reilly))

    In Stock.
    Ships from and sold by Amazon.com.
    Eligible for FREE Super Saver Shipping on orders over $25. Details



Editorial Reviews

From the Back Cover

Sams Teach Yourself PL/SQL in 21 Days, Second Edition, quickly empowers you to create your own Oracle solutions with PL/SQL. Completely revised to cover Oracles 8i, the book provides guidance and direction, leading you through a progression of topics that begin with the basic building blocks of PL/SQL, and ending with in-depth discussions of the more commonly used advanced features of Oracle's database programming environment. New topics include extended dynamic SQL within PL/SQL, Dynamic SQL within PL/SQL, use of invoker's rights, autonomous transactions, interfacing PL/SQL with Java, PL/SQL Bulk Binds, parameter passing by reference, and advanced Querying.

About the Author

Jonathan Gennick is a professional developer with over seven years of experience working with relational database technology. As the lead database administrator for the utilities group of KPMG, Jonathan¿s duties include assisting programmers who need to write stored procedures and database triggers using Oracle PL/SQL. A member of MENSA, Jonathan holds a degree in Information & Computer Science from Andrews University in Berrien Springs, Michigan. His writing career began in 1997, when co-authored Teach Yourself PL/SQL in 21 Days. Since then he has been involved with four other book projects, serving as technical editor for Oracle8 Server Unleashed, the development editor for Sams Teach Yourself Access 2000 in 24 Hours, a technical reviewer for Oracle Database Administration, The Essential Reference, and the author of SQL*Plus, the Definitive Guide.


Product Details

  • Paperback: 720 pages
  • Publisher: Sams; 2 edition (January 1, 2000)
  • Language: English
  • ISBN-10: 0672317982
  • ISBN-13: 978-0672317989
  • Product Dimensions: 9.2 x 7.4 x 1.4 inches
  • Shipping Weight: 2.4 pounds (View shipping rates and policies)
  • Average Customer Review: 2.9 out of 5 stars  See all reviews (10 customer reviews)
  • Amazon Best Sellers Rank: #727,827 in Books (See Top 100 in Books)

More About the Author

I am an Oracle DBA, computer book editor, and writer residing in Munising, Michigan, and only six

blocks from Lake Superior. If you want to know more about me, please visit http://Gennick.com.

 

Customer Reviews

10 Reviews
5 star:
 (3)
4 star:
 (2)
3 star:    (0)
2 star:
 (1)
1 star:
 (4)
 
 
 
 
 
Average Customer Review
2.9 out of 5 stars (10 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

28 of 28 people found the following review helpful:
1.0 out of 5 stars 2 Authors -- one good, one really, really bad, September 19, 2001
By 
Lucy Z. Regan (Bellevue, WA United States) - See all my reviews
(REAL NAME)   
This review is from: Sams Teach Yourself PL/SQL in 21 Days (2nd Edition) (Paperback)
After reading the first 3 chapters of this book, I was thinking to myself "Wow! This book is great". However, moving on to chapter 4, it felt like a bus fell on me. I read the next few chapters in stunned amazement, wondering what happened, and then I discovered it -- the first three chapters had been written by a different author than the current chapters that I was struggling through.

Where the first chapters, written by Jonathan Gennick, had pertinent, precise examples and a good development of the subject matter, the subsequent chapters (4-9), written by Tom Luers, contained error after error with poor development of the subject matter. The naming of variables was confused and the case of variables and keywords changed from example to example (and even within the same example!).

When I started reading this book, I typed all the examples into Personal Oracle to experiment along with the text. In addition, I placed small "sticky" notes on each page where I encountered an error in the text. I found only a few in the first few chapters. However, after hitting chapter 4, I found myself putting notes on at least every other page, and sometimes multiple notes on a single page! After struggling through several chapters of Luers' writing, I could no longer bring myself to type in the examples -- actually, some of the examples were based on tables that had not even been covered yet in the text, making it impossible to try them. Also, because of the huge number of errors, I stopped adding "sticky" notes, lest I run out of my supply.

Sadly, I cannot recommend this book (even though I found the chapters written by Gennick to be very good). If you do buy this book, read chapters 1-3, 10-13, 16-17, and 20-21, and skip the rest.

My final thoughts: I cannot believe that a publisher would sell a book with such an amazing number of errors, or that such a solid technical author would partner with such an incapable one.

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


23 of 24 people found the following review helpful:
4.0 out of 5 stars Good for CompSci majors considering an OCP, October 19, 2000
By 
Timothy Walker (Orlando, Florida USA) - See all my reviews
(VINE VOICE)    (REAL NAME)   
This review is from: Sams Teach Yourself PL/SQL in 21 Days (2nd Edition) (Paperback)
I generally agree with the other reviewers on this book - despite some errors, it is a solid set of PL/SQL lessons. Great results can be produced by using the book as designed (download a copy of Personal Oracle, and spend three hours a day hacking the &@:=#! out of it). However, these favorable reviews can be misleading, as they lack a "Who is this book for?" section. Unlike many "Teach Yourself" titles, this is not good reading for the absolute novice. To get the most from this book, you should have:

1. Functional and theoretical knowledge of at least one high-level programming language.

2. A good understanding of database theory and terminology.

3. Some experience with SQL (and ideally with Oracle, but if you can make Access do tricks, you'll be fine).

4. Three weeks off. ;-)

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


15 of 15 people found the following review helpful:
4.0 out of 5 stars Gets the job done, March 13, 2000
This review is from: Sams Teach Yourself PL/SQL in 21 Days (2nd Edition) (Paperback)
This book is pretty good. Each of the 21 lessons takes a couple of hours to read, so the pace is about right. I learned a lot of PL/SQL from this book, so I'm glad I bought it.

The book is pooly edited, though, and is full of errors. A couple of times there were serious errors in the example programs, but they weren't enough to spoil the book.

If you have a little programming experience, you might try just using the PL/SQL chapters in the Oracle8: The Complete Reference. You're going to need a book like that anyway....

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews








Only search this product's reviews



What Other Items Do Customers Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 

Your tags: Add your first tag
 

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 Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums



So You'd Like to...


Create a guide


Look for Similar Items by Category


Look for Similar Items by Subject