Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
I'm looking for: Advanced options

Please note: This page is not maintained anymore. Please visit the new and improved page at http://www.orafaq.com/books/plsql

Index > Oracle Books > PL/SQL Books

Buy this Book Oracle PL/SQL Programming, 4th Edition
by Steven Feuerstein, Bill Pribyl
excellent resource for programmers using this language. Highly recommended which is why I purchased it.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle Database 10g PL/SQL Programming
by Scott Urman, Ron Hardman, Michael McLaughlin
Highly recommended!
Book incorporated more detailed features and explanations with up to date technology examples (covering 9i and 10g in depth). I think I should not only use this book for my certification but also keep it with me as a reference guide too.

So far what I felt in most of the chapters, it really require previous background on the topics Or it takes little more time to cover some areas (new features).

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle JDeveloper 10g for Forms & PL/SQL Developers: A Guide to Web Development with Oracle ADF (Osborne Oracle Press)
by Peter Koletzke, Duncan Mills
Highly recommended!
As the authors note, this is written for people who know PL/SQL inside and out but don't have a clue about java and JDeveloper - my exact position. The first read through gave me a clearer picture, and the subsequent reads are finally lifting the fog.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle PL/SQL by Example, Third Edition
by Benjamin Rosenzweig, Elena Silvestrova
Highly recommended!
I'm a developer and DBA who had not written PL/SQL in over a year. I used this book as a refresher.

This is the "Learning Perl" of PL/SQL, meaning: a beginner can learn from it, and an experienced hack can use it as a reference.

I consider lots of good sample code to be important when learning a programming language. Here it is, as a series of labs, with intelligent discussion. It's like having a friend who's an expert act as a personal tutor. It has complete, well-rounded coverage of PL/SQL fundamentals: control structures, stored ...

It is nearly the quality of Oracle course materials, but with (a tolerable amount of) typos. Annoyingly, some of the typos are incorrect answers in the appendix; the rest are obvious typos and therefore not too confusing.

Chapter 1 is deceptively basic, explaining what a program is, what a programming language is, etc., but chapter 2 jumps right into PL/SQL with no further ado. The book progresses in baby steps as far as PL/SQL is concerned. Although knowledge of SQL is assumed, some concepts like commit & rollback, savepoints, and sequences are introduced and explained for beginners. It is also assumed that the reader:

- knows what DML, DDL, and the DUAL table are;
- has an account that can create objects (the "Scott" demo account will do); and
- knows how to connect to the database with SQL*Plus or a development tool (IDE).

With an IDE I was able to work through it in about thirty hours. I just read chapters I was already strong in without working those labs, but that time included plenty of puttering and experimenting with the lab material I did work.

I also bought 10g "PL/SQL Programming" by Urman, et. al. but dove into this book first. The two books overlap. The freely available "PL/SQL User's Guide and Reference" from Oracle is still a must-have.

Densely packed with pertinent information and very little else, it's about 99% useful information. Like the blurb says, "Just the facts." It is a complete Oracle course, so it was worth $2400 in that respect.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle Developer Advanced Forms and Reports
by Peter Koletzke, Paul Dorsey
This book is a great tool for creating Visual Basic Applications

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle Database 10g PL/SQL 101
by Christopher Allen
This book is good for beginner. It introduces most of the basic pl/sql fundamentals.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle PL/SQL Best Practices
by Steven Feuerstein
Simply put, this book should be required reading for anyone who considers themselves a professional PL/SQL developer. It is full of pearls and gems, and succinctly presents many, many programming proverbs that must be followed if developing in 0racle

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book OCP Developer PL/SQL Program Units Exam Guide
by Steve O'Hearn
Highly recommended!
Amazing...great..those are the words for this book which i recently used for 1z0-147 exam which i passed with score 63/66.
After lot of research i used this book for 1z0-147 and i happily confirm that i made great choice.

Most of the topics required for exam are covered except LargeObjects(LOB).

Thanks a lot Steve for wonderful job.!!!!!!!

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle PL/SQL For Dummies
by Michael Rosenblum, Paul Dorsey
Highly recommended!
This book is an excellent introduction to both PL/SQL and general coding principles. It is a good book for beginners and old dogs alike. It provides simple, clear and useful introductions to advanced topics such a INSTEAD OF TRIGGERS, BULK COLLECTS etc. My team is now using it a our "best practice" document for PL/...

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Mastering Oracle PL/SQL: Practical Solutions
by Connor McDonald, Chaim Katz, Christopher Beck
Highly recommended!
The book is good but many solutions are not tested fully so its not that they can be cut and pasted directly out of the book. you may have to troubleshoot many of them. Otherwise a real good book.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle Database 10g XML & SQL: Design, Build, & Manage XML Applications in Java, C, C++, & PL/SQL (Osborne ORACLE Press Series)
by Mark Scardina, Ben Chang, Jinyu Wang
This book covers everything on how to develop XML applications based on the Oracle XML infrastructure. It also provides the readers with a lot of samples on how to utilize the technology. No matter you are an advanced professional or a fresh graduate, if you are interested in XML-related Oracle application development...

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Expert Oracle PL/SQL (Osborne Oracle Press)
by Ron Hardman, Michael McLaughlin
Highly recommended!
No review available!

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle PL/SQL Language Pocket Reference, 3rd Edition
by Chip Dawes, Steven Feuerstein, Bill Pribyl
This small booklet "ORACLE PL/SQL Language Pocket Reference" in this new 2nd edition is exactly what you need as PL/SQL (PL/SQL is the ORACLE procedural language extension of SQL) programmer (and is even more important for casual PL/SQL programmer).
"ORACLE PL/SQL Language Pocket Reference" assumes that you are ...

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle9i PL/SQL Programming
by Scott Urman
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

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle9i: A Beginner's Guide
by Michael Abbey, Michael J Corey, Ian Abramson
I read the reviews posted above, and was discouraged, but I needed an Oracle reference right away and this was the only book available at the library. Just as one person said, the first 2 chapters aren't wholly necessary and promote Oracle a lot. On the other hand, the book is printed by the Oracle Press. Chap. 3 ...

It is a lot at once for a true novice. I'm not so bad -- I had a pretty good crash course on relational DB ideas and SQL in 2 lectures of a web programming class once, for use with mySQL. This book is good enough to explain the Oracle side of things. And the writing isn't all that bad, i.e. it's more than just a copy of the manuals, IMO. It suits me well enough as an intro to the Oracle syntax and way of doing things.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle PL/SQL for DBAs
by Arup Nanda, Steven Feuerstein
Highly recommended!
Are you a developer or database administrator? If you are, then this book is for you! Authors Arup Nanda and Steven Feuerstein, have done an outstanding job of writing a book that allows you to take advantage of the PL/SQL-based functionality in the Oracle database that is the most critical for DBAs...

Nanda and Steven Feuerstein, begin by providing a whirlwind tour of the PL/SQL language, touching on all of the topics DBAs will need to become familiar with--from the basics of the PL/SQL block structure, identifier construction, and program data declarations, to the use of control and error-handling statements, to the construction of procedures, functions, packages, and triggers in PL/SQL. Then, the authors describe PL/SQL cursors and how you can improve database performance by taking advantage of such features as cursor reuse, cursor soft-parsing and soft-closing, and various characteristics of implicit cursors. Next, they explore the use of functions that can be used as data sources for queries and that are used frequently in Extraction, Transformation, and Loading (ETL) operations. The authors then explain how you can use Oracle's tools to build basic encryption and key management systems to protect sensitive data. They continue to explain how you can define policies on database tables so that you can restrict which rows particular users can see or change in those tables. Then, the authors show you how you can extend traditional Oracle auditing to capture both database changes and queries. Next, they discuss situations in which you may need to generate values. Finally, they describe the use of the DBMS_SCHEDULER package in scheduling jobs to be performed at regular intervals.

This most excellent book is here to help you get your job done. More importantly, this book is focused squarely on the language topics of special concern to DBAs.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle9i Developer: PL/SQL Programming
by Joan Casteel
This is a text book - this book is written specifically for college classes. Any books you see that are published by Course Technology are text books.
This book is written in a format that user's with only SQL knowledge and are brand new to PL/SQL can learn the fundamentals of PL/SQL programming. The text covers...

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle9i: SQL, with an Introduction to PL/SQL
by Lannes Morris-Murphy
Highly recommended!
I liked this book. Coming from SQL Server 2000 to the Oracle environment, I had a lot of questions. This book covered the subject material completely without over-coaching or being too simple.

It was an excellent read and a book that I refer to often. Well written.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Advanced Oracle PL/SQL Programming with Packages (Nutshell Handbook)
by Steven Feuerstein
I like this book but it could have been better if it dealt with PL/Vision alot less and about Oracle Package construction in general alot more. The book is more of a 30-70% split in favor of PL/Vision. It was very helpful, but it seemed like an ad for the writer's software at times.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Sams Teach Yourself PL/SQL in 21 Days (2nd Edition)
by Jonathan Gennick, Tom Luers
I am a professional Accountant/ Auditor (CPA from USA) and heading finance division in a corporate, with a turnover over $ 2 billion. As our organization is undergoing ERP and I have been made as Implementation Committee member from the client side, I have been looking into Oracle. I don't have any knowledge of any ...

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle PL/SQL Developer's Workbook
by Steven Feuerstein
Highly recommended!
If there is any book which will "fine-tune" one's knowledge of PL/SQL, this is it. It is written in Feuerstein's inimitable style which will keep you engaged with the book much longer than any other peer book of it's kind. There is so much to learn from this book really - and it applies to beginners as experts alike. ...

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Building Oracle XML Applications
by Steve Muench
Highly recommended!
This book with real working code samples saved the day for me when building an XML Loader. One drawback: It doesn't explain XSL real well which is crucial for transforming your XML document into the canonical format so I really give it 4.5 stars.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle PL/SQL 101
by Christopher Allen
Highly recommended!
This is a great book for the very beginner person who has no experience at all in SQL. It is very in details and very easy to understand. Unfortunately, I have to return this book since it is not what I am looking for.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book OCP Oracle9i Database: Fundamentals I Exam Guide
by Jason Couchman, Sudheer Marisetti
This book does not cover all the details for Fundamentals II. It is a good source for reference. The CD accompanied with the book has wrong answers for the questions. You may need to refer additional book(s), may be sybex one along with this one.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Ocp: Oracle8I Dba SQL and Pl/SQL Study Guide : Exam 1Z0-001 (OCP Study Guide)
by Chip Dawes, Biju Thomas
I used this book for the 1Z0-007 Exam and I passed with a score of 48/52 !!. It includes almost all the chapters.
You just need to study the new oracle 9i features.
Great book !!

Thanks a lot.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Learning Oracle PL/SQL
by Bill Pribyl
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 ...

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle Web Application Programming for PL/SQL Developers
by Susan Boardman, Melanie Caffrey, Solomon Morse
Highly recommended!
Written much like the math textbooks of your youth (complete with exercises at the end of each section), Oracle Web Application Programming for Pl/SQL Developers is a godsend for those of us who knew you could write web apps using PL/SQL, but lacked the actual syntax to do so. Book can be used as either a reference or...

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle PL/SQL Interview Questions, Answers, and Explanations: Oracle PL/SQL FAQ (Oracle Interview Questions)
by Terry Sanchez




In agreement with other reviers: this book is filled
with technical details about Oracle PL/SQL,
and it will certainly assist me in my job search. As a
beginner in Oracle, may of the publication that I find
are very technical. This guide is included in that list.

But I do find the information of some use.

The book is expensive, but I find that you get
what you pay for. It is worth the purchase.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts
by John Adolph Palinski
The review by the reviewer from Lincoln does not pertain to this book. The book pertains to my book "Oracle Database Construction Kit" that was written in 1997 and is out of date even though the publisher continues to market it. At the time "Oracle Database" was published Forms Builder 4.5 was the current product and...

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Teach Yourself Pl/SQL in 21 Days (Sams Teach Yourself)
by Tom Luers, Timothy Atwood, Jonathan Gennick
I've found this book very helpfu

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle in a Nutshell
by Rick Greenwald, David C. Kreines
When I purchased Oracle in a Nutshell I thought I would need to buy another book for a quick reference to the data dictionary views but to my pleasant surprise these were included too.
A great book but it's not for the weekend-warrior DBA. If you can create indexes, tables, tablespaces, users, instances and ...

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle9i: SQL (with an Introduction to PL/SQL)
by Lannes Morris-Murphy
Highly recommended!
One of the best IT books I've ever read. Well written, the hands-on assignments are highly useful for learning Oracle SQL. I strongly recommend Oracle9i SQL by Lannes Morris-Murphy.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle 9i Java Programming: Solutions for Developers Using PL/SQL and Java
by Bjarki Holm, John Carnell, Tomas Stubbs
This book was a real life saver for me! Detailed deployment guidelines and intuitive examples, gave me my money's wortth. Two thumbs up!

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle8i DBA: SQL and PL/SQL Exam Cram (Exam: 1Z0-001)
by Michael R. Ault, Michael Ault
Its a good book review before giving the exam. Helps in brushing all the important concepts and syntax.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle8i DBA: SQL and PL/SQL Certification Bible
by Damir Bersinic, Stephen Giles, Susan Ibach
Highly recommended!
This book set me on the right path! Having had no experience with Oracle, I had study only this book, went through its practice questions and lab exercises, and in 1-1/2 month's time, I passed my first exam with flying colors! If anyone is interested in becoming a OCP for Oracle9i and want to also validate your ...

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle PL/SQL CD Bookshelf
by Inc. O'Reilly & Associates
Highly recommended!
This a great all-inclusive resource for Oracle SQL developers. Though focusing on 8i and not on the newer 9i, the concepts are still helpful. Suitable for intermediate and advanced developers.

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Oracle PL/SQL Interactive Workbook (2nd Edition)
by Benjamin Rosenzweig, Elena Silvestrova
I bought this in hoping to find a PL/SQL book that could give me a real life lab exercise. I gave up on this book. The examples would sometime refer to advanced topics not discussed. There were errors. The exercises did not appear to be kitchen tested before the book was published. I am still looking for a good PL/SQL ...

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


Buy this Book Professional Oracle 8i Application Programming with Java, PL/SQL and XML
by Michael Awai, Matthew Bortniker, John Carnell
Some other reviewers have stated that this book is uneven in quality. I agree with that assessment but argue that is unavoidable. I cannot think of any one person who possesses the knowledge to write intelligently about all of this material in the depth this book has.
In a few areas it is dated (obviously 9i is ...

Buy from: [ US ] [ UK ] [ DE ] [ JP ]


38 books listed. Updated: 24 Feb 2007

HOME | ASK QUESTION | ADD FAQ | SEARCH | E-MAIL US