Order from a Major Online Bookstore
Ultimate Book Price Comparison Engine
Save Your Time And Money
| AnyBook4Less.com | Order from a Major Online Bookstore |
|
| Home | Store List | FAQ | Contact Us | | ||
| Ultimate Book Price Comparison Engine Save Your Time And Money |
||
 |
Title: Learning Oracle PL/SQL by Bill Pribyl ISBN: 0-596-00180-0 Publisher: O'Reilly & Associates Pub. Date: 15 December, 2001 Format: Paperback Volumes: 1 List Price(USD): $39.95 |
Average Customer Rating: 4.08 (12 reviews)
Rating: 4
Summary: One of the best intros to PL/SQL
Comment: 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.
Rating: 4
Summary: Overall very good
Comment: 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.
Rating: 1
Summary: Learning Oracle Maybe, But Not PL/SQL
Comment: 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.
 |
Title: Oracle PL/SQL Programming, Third Edition by Steven Feuerstein ISBN: 0596003811 Publisher: O'Reilly & Associates Pub. Date: 23 September, 2002 List Price(USD): $54.95 |
 |
Title: Oracle PL/SQL Developer's Workbook by Steven Feuerstein ISBN: 1565926749 Publisher: O'Reilly & Associates Pub. Date: 15 May, 2000 List Price(USD): $36.95 |
 |
Title: Oracle PL/SQL Best Practices by Steven Feuerstein ISBN: 0596001215 Publisher: O'Reilly & Associates Pub. Date: 15 April, 2001 List Price(USD): $19.95 |
 |
Title: Mastering Oracle SQL by Sanjay Mishra, Alan Beaulieu ISBN: 0596001290 Publisher: O'Reilly & Associates Pub. Date: April, 2002 List Price(USD): $34.95 |
 |
Title: Oracle SQL*Plus: The Definitive Guide by Jonathan Gennick ISBN: 1565925785 Publisher: O'Reilly & Associates Pub. Date: 01 March, 1999 List Price(USD): $39.95 |
Thank you for visiting www.AnyBook4Less.com and enjoy your savings!
Copyright� 2001-2021 Send your comments
