Learning Oracle PL/SQL

Rating:
Summary: Exactly the kind of book I was looking for
Review: 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:
Summary: One of the best intros to PL/SQL
Review: 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:
Summary: I recommend this book
Review: 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.

Rating:
Summary: Everything you need to know about PL/SQL
Review: This 300+ page book is a gem. It goes straight to the point about how to use PL/SQL. With clear examples and tips to make you a better developer.

Rating:
Summary: The Perfect "college" textbook
Review: Though by the time this book came out, I've become an intermediate PL/SQL guru, I decided to buy it anyway, just to read it and perhaps maybe gain some insight that may have been overlooked in the original "bible" Oracle PL/SQL Programming, 2nd. Ed.

The book is concise with one and only one project example to lead you through all the PL/SQL constructs and when and why they are used. For me, I skimmed through it but did find help on "overloading" in packages which isn't discuss since it is a "beginner's" book.

Kudos to Bill and Steve for a great book. I can add it to my library of Oracle based O'Reilly publishing books.