Product Description
Design Feature-Rich PL/SQL ApplicationsDeliver dynamic, client/server PL/SQL applications with proficient counselling from an Oracle planning professional. With flooded news of the stylish features and tools, Oracle Database 11g PL/SQL Programming lays discover apiece matter alongside careful explanations, cut-and-paste structure examples, and real-world housing studies. Access and add database information, create coercive PL/SQL statements, fulfil trenchant … More >>
Oracle Database 11g PL/SQL Programming
Popularity: 1% [?]
I’ve been using PL/SQL for a few years, but not often and not well. I wanted a book that would serve as both a reference book and as a cover-to-cover read from which I could absorb all the niceties.
This isn’t that book. As a reference book, I think it’s okay, but as a read it was pretty bad. The book has a lot of cut-and-pasting, with paragraphs lifted from one chapter and dropped in another (albeit relevant) chapter, or similar information repeated redundantly. For example, CHAR, NCHAR, VARCHAR2 and NVARCHAR2 are awfully similar data types, but instead of combining them into a single section and describing what they have in common and how they differed, the same long paragraph was repeated, tweaking a few words. That might be okay for a pure reference book (hence two stars rather than one), but it sure makes for a dull read, and it just makes the book heavier.
I returned the book before finishing it (and wouldn’t that be cheating?), but searching the text there were some things that seemed missing. My current project will involve a SELECT-FOR-UPDATE cursor loop, and I couldn’t find a description of it.
Rating: 2 / 5
Oracle Database 11g PL/SQL Programming (Oracle Press)
I use this book in conjunction with a second I had to buy called “Oracle Database 11g: The Complete Reference”. The PL/SQL Progaming is excellent in decribing how to what I want to achieve. However it had no reference to the available functions and the syntax. That is why I got the second book. The second book may not be the best option, but it is helpful. I am new to Oracle in general, but I have extensive eperience in MS SQL Server. In “PL/SQL Programming” I have been staying in the first three parts of the book. I will go on the latter parts next quarter. This is not a book for beginner’s. I am experienced, but no guru in MS SQL Server so most this book was readable to me. However the book covers a wide range of topics, therefore some individuals who only want part of the book may need to look elsewhere.
Rating: 4 / 5
I have been working with PL/SQL for several years and I am now preparing for an OCP exam. I find the style of McLaughlin’s book not well suited for exam preparations. Some parts of the text are a bit confusing, occasionally he introduces terms without explaining them, on the other hand he presents the same definitions multiple times in every new section. Lot of important details are never mentioned while some rarely used features get a lot of attention. Also the examples are not all error free. I have put this book aside and use for my preparations the slightly dated “OCP Developer PL/SQL Program Units Exam Guide” from Steve O’Heran. This book is much better suited for an exam preparation. I will only look up the new features in McLaughlin’s book.
Rating: 2 / 5
This book is great! It’s a fabulous book to use as a resource within projects. It’s a tool specifically designed to teach the user the best in database management systems. Would highly recommend this book for anyone’s use!
Rating: 5 / 5
This is probably one of the worst books you can find for Oracle 11g PL/SQL. With so many typos all over the book, Reading this is not going to be very pleasant. The author could have tried to save the reader’s time by avoiding redundant information. For instance he explains about CLOB in few pages and when he comes to explain BLOB, it’s just Copy paste CLOB explanation, Find the word ‘CLOB’ and replace with ‘BLOB’. Though this book is not meant to help you pass the Oracle PL/SQL exam, I guess a good technical book should have exercises, but this one does not. The irony is this one of the very few books available for Oracle 11g PL/SQL programming.
Rating: 2 / 5