Its a very good book. covers all the finincial modules very well. Gives the whole flow of data in them. but the newer edition is even better it covers extra modules as well. wil help u in getting a wider view. So i would recomend u to go for the newer edition if u need a wider idea of diff modules

You will learn how to create anonymous blocks, stored procedures, stored functions, triggers (Before | After | Instead Of), packages, CASE statements, if and else if statements, while loops, for loops, goto's, insert, update, delete, truncate, native dynamic SQL (EXECUTE IMMEDIATELY `';), and more. The book is filled with lots of complete examples, and a light speech of how the code works. I also recommend this book over the 8i Oracle Books by Scott Urman because Oracle 9i added a lot of new features that make PL/SQL programming more dynamic and easier to use than it's predecessor code, which is still available in the new Oracle 9i. I also recommend Oracle9i Developer PL/SQL programming ISBN 061915909X for understanding the code and Oracle 10g PL/SQL Programming ISBN 0072230665 for learning the new 10g PL/SQL features.

The Oracle 10g Release 2 database can be downloaded from Oracle for free [...]. I also recommend learning a Web Application language like ASP.NET or JavaServer Pages. The book to learn ASP.NET v1.x is ASP.NET 2003 or 2005 Unleashed ISBN 067232542X. Oracle Data Provider for .NET can be downloaded from Oracle too. PL/SQL is a simple language (My First Virgin) and I personally recommend this book for new Database Developers.

Maybe one day you will be able to develop Procedures like this:
CREATE OR REPLACE PROCEDURE dominic.sp_transaction
(p_orid ROWID,
p_ordid NUMBER)
IS
v_shipping NUMBER;
v_subtotal NUMBER;
v_tax NUMBER;
v_total NUMBER;
v_errmsg VARCHAR2(80);
v_errcode VARCHAR2(10);
BEGIN
-- (packprice * qty * packid * distance) AS shipping
-- (qty * price * taxrate) AS tax
-- (price * quantity) AS SubTotal
SELECT SUM((p.pack_price * l.quantity) * (l.quantity * l.packid) * DECODE(st.distance, '', c.distance, st.distance)),
ROUND(SUM(l.quantity * DECODE(p.active, 'Y', p.saleprice, 'N',p.price) * DECODE(st.tax, '', 0, st.tax)),2),
SUM(l.quantity * DECODE(p.active, 'Y', p.saleprice, 'N',p.price))
INTO v_shipping, v_tax, v_subtotal
FROM product p, order_line l, shipping s, state st, country c
WHERE p.productid = l.productid AND l.shipid = s.shipid AND s.shipstate = st.state(+) AND s.shipcountry = c.country
AND l.orderid = p_ordid;
--calculate total
v_total := v_shipping + v_tax + v_subtotal;
UPDATE dominic.orders
SET subtotal = v_subtotal, shipping = v_shipping, TAX = v_tax, Total = v_total
WHERE rowid = p_orid;
EXCEPTION
WHEN OTHERS THEN
v_errmsg := SUBSTR(SQLERRM,1,80);
v_errcode := SQLCODE;
sp_dberror('N/A', 'N/A', v_errmsg, v_errcode, 'SP_TRANSACTION');
END;
/

You will learn how to create anonymous blocks, stored procedures, stored functions, triggers (Before | After | Instead Of), packages, CASE statements, if and else if statements, while loops, for loops, goto's, insert, update, delete, truncate, native dynamic SQL (EXECUTE IMMEDIATELY `';), and more. The book is filled with lots of complete examples, and a light speech of how the code works. I also recommend this book over the 8i Oracle Books by Scott Urman because Oracle 9i added a lot of new features that make PL/SQL programming more dynamic and easier to use than it's predecessor code, which is still available in the new Oracle 9i. I also recommend Oracle9i Developer PL/SQL programming ISBN 061915909X for understanding the code and Oracle 10g PL/SQL Programming ISBN 0072230665 for learning the new 10g PL/SQL features.

The Oracle 10g Release 2 database can be downloaded from Oracle for free (www . otn . oracle . com). I also recommend learning a Web Application language like ASP.NET or JavaServer Pages. The book to learn ASP.NET v1.x is ASP.NET 2003 or 2005 Unleashed ISBN 067232542X. Oracle Data Provider for .NET can be downloaded from Oracle too. PL/SQL is a beautiful language live it, love it, and code it.

The book is good and is recommended for someone new to PL/SQL. For someone who is already familiar to PL/SQL, you can save money by going through the Oracle Online Manual to read about the new features of PL/SQL in Oracle 9i. Since I already had a previous version (Oracle 8) of this book, I consider buying this book as waste of money. But if you are just getting into the world of oracle and you want to learn PL/SQL, this book is for you. One nice thing about the book is it comes with a CD that has some trial version of some development environments. Nice to explore those.
I give 4 stars.

The book is good and is recommended for someone new to PL/SQL. For someone who is already familiar to PL/SQL, you can save money by going through the Oracle Online Manual to read about the new features of PL/SQL in Oracle 9i. Since I already had a previous version (Oracle 8) of this book, I consider buying this book as waste of money. But if you are just getting into the world of oracle and you want to learn PL/SQL, this book is for you. One nice thing about the book is it comes with a CD that has some trial version of some development environments. Nice to explore those.
I give 4 stars.

This is, indeed, a great book to pass this exam(1Z0-147). Actually, there is no prescribed book(as of now!!), for this exam. This book fairly covers most of the topics that are specified in the official exam syllabus. However, topics on Large objects are not covered in this book extensively. I suggest to search on google for LOBS(This is how i got some notes on LOBS). This book is good to study functions, procedures, packages, triggers, and some DBMS packages, but it doesn't cover LOBS, managing dependencies. Overall, I can give 4 stars to this book, as it helped me to pass the exam.

This is a well written, fast reading book that provides the reader with the information needed but not with the fluff that we do not need. I used this book to pass the Oracle Certification Exan 1Z0-147 : Oracle9i: Program with PL/SQL. If you own this book and 'Oracle PL/SQL' by Steven Feuerstein and Bill Pribyl (published by O'reily), you probably have what you need (for understanding PL/SQL) ... enjoy

This is a well written, fast reading book that provides the reader with the information needed but not with the fluff that we do not need. I used this book to pass the Oracle Certification Exan 1Z0-147 : Oracle9i: Program with PL/SQL. If you own this book and 'Oracle PL/SQL' by Steven Feuerstein and Bill Pribyl (published by O'reily), you probably have what you need (for understanding PL/SQL) ... enjoy

I must say it is not what I expected. Basically, if you know nothing about PL/SQL, that is, the Oracle extension of the SQL, and you need to grasp its general concept in a very short time, this is the book for you.

But the subtittle of the book is definitely misleading. When it comes to advanced topics, the book simply copies from the online documentation from Oracle, but only the brief summery. Say, function DECODE, one of the most powful feature in PL/SQL, is covered in half a page! Just the official definition. Nothing to read about. If you bought Oracle 9i The Complete Reference, you'd find a whole chapter devoted to that function.

The author didn't do much work with this book. If you're a serious programmer, don't bother with this book.

This is a pretty decent book with plenty of advanced topics. Other than the fact that not all the advanced topics were covered I'm pretty happy with this edition.

I purchased the book having a little knowledge about PL/SQL programming and unfortunately reading this book didn't enhance my specific culture.
Nevertheless I think that it is a good item for novice PL/SQL programmer. They will find it an unvaluable working and training tool.
Finally, in my opinion, the preceding edition was richer in terms of contents and arguments.

I purchased this book knowing nothing about PL/SQL. I read the entire book and worked through most of the examples in a week of dedicated self-training. The material is presented in a logical order. All the examples worked. Although all scripts are provided on the CD that comes with the book, I typed in all examples which helped in learning the material. The only issue I had with some of the examples is the use of the DBMS_OUTPUT package. This package writes the output of some of the examples to the screen. However, it only does so in SQL*Plus or Server Manager. I was using a tool by Quest called TOAD. I compensated for this by sending the output to a temp table provided by the author and then queried the temp table to retrieve the results. It worked just fine. Working through the examples requires the Oracle database, which shouldn't be a problem since anyone can download Oracle for free from Oracle's website. I give the book a big thumbs up! I definitely feel I have the knowledge necessary to go out and write PL/SQL.

I have several books by Urman. I have both 8i PL/SQL Programming books by Urman, as well as the 2001 edition of the 9i PL/SQL Programming book.

The 8i edition of this book is is 978 pages. The 2001 edition of the 9i book is 631. The 9i book has much less content than the 8i book even though more features have been added to Oracle 9i. There is also a large "Advanced" 8i PL/SQL Programming book because the basic book is just not big enough at 978 pages!

My conclusion is that while you MUST own this book, the 9i book does not adequately cover PL/SQL programming. Too much is left to the reader to puzzle-out on his own using other books and resources like Metalink or on-line documents. Why the book shrunk since 8i is a real mystery . . .