| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
Index > Oracle Books > PL/SQL Books
| ||
|
|
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. |
|
|
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). |
|
|
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. |
|
|
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. |
|
|
Oracle Developer Advanced Forms and Reports by Peter Koletzke, Paul Dorsey | This book is a great tool for creating Visual Basic Applications |
|
|
Oracle Database 10g PL/SQL 101 by Christopher Allen | This book is good for beginner. It introduces most of the basic pl/sql fundamentals. |
|
|
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 |
|
|
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.!!!!!!! |
|
|
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/...
|
|
|
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. |
|
|
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... |
|
|
Expert Oracle PL/SQL (Osborne Oracle Press) by Ron Hardman, Michael McLaughlin Highly recommended! | No review available! |
|
|
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 ... |
|
|
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 |
|
|
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. |
|
|
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. |
|
|
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... |
|
|
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. |
|
|
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. |
|
|
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 ... |
|
|
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. ... |
|
|
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 |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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 ... |
|
|
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... |
|
|
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. |
|
|
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... |
|
|
Teach Yourself Pl/SQL in 21 Days (Sams Teach Yourself) by Tom Luers, Timothy Atwood, Jonathan Gennick | I've found this book very helpfu |
|
|
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 ... |
|
|
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. |
|
|
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! |
|
|
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. |
|
|
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 ... |
|
|
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. |
|
|
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 ... |
|
|
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 ... |
38 books listed. Updated: 24 Feb 2007 | ||
![]() |
![]() |