Oracle PL/SQL Programming Review

Average Reviews:

(More customer reviews)Are you looking to buy Oracle PL/SQL Programming? Here is the right place to find the great deals. we can offer discounts of up to 90% on Oracle PL/SQL Programming. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Oracle PL/SQL Programming ReviewI recommend this book wholeheartedly for beginners as well as veterans of PL/SQL. Especially against the Oracle Press book by author Scott Urman. That book (though it covers the basics), it does not give you the tips and tricks or insight as does Steve's book.
The O'Reilly series book is well crafted, with excellent examples. The style of writing is humorous as well as straight forward. And it is a companion amongst other Oracle books by O'Reilly. O'Reilly Publishing seems to know Oracle better than Oracle Press knows itself.
GioOracle PL/SQL Programming Overview
The first edition of Oracle PL/SQL Programming quickly became anindispensable reference for both novice and experienced PL/SQLdevelopers. Packed with examples and recommendations, it helpedeveryone using PL/SQL (from the Oracle Forms developer to the databaseadministrator) make the most of this powerful language.

Oracle8 presents PL/SQL programmers with new challenges by increasing both the possibilities and complexities of the language.This newedition updates the original book for Oracle8, adding chapters describingthe new PL/SQL object features (object types, collections, object views, and external procedures). The second edition also contains a much-requestedchapter on tuning PL/SQL, as well as expanded discussions of debuggingand tracing PL/SQL execution.

The book comes with a companion diskette containing the Companion UtilitiesGuide for Oracle PL/SQL Programming, an online tool developed by RevealNet,Inc. The online guide contains more than 100 file of source code anddocumentation prepared by the authors.

Even if you've already read the first edition of Oracle PL/SQL Programming,you'll find an enormous amount of new and revised information in thissecond edition and on its companion diskette. If you're new to PL/SQL,you'll soon find yourself on the road to mastery.

NOTE: To make room for the new material, some summaries and code from the first edition have been moved to the companion disk.

Oracle PL/SQL Programming is divided into seven parts:

Foreword Preface

Part I: Programming in PL/SQL
1. Introduction to PL/SQL2. PL/SQL Language Fundamentals3. Effective Coding Style
Part II: PL/SQL Language Elements 4. Variables and Program Data5. Conditional and Sequential Control6. Database Interaction and Cursors7. Loops8. Exception Handlers9. Records in PL/SQL10.PL/SQL Tables Part III: Built-in Functions and Packages 11. Character Functions12. Date Functions13. Numeric, LOB, and Miscellaneous Functions14. Conversion Functions
Part IV: Modular Code 15. Procedures and Functions16. Packages17. Calling Stored PL/SQL Functions from SQL
Part V: PL/SQL Oracle8 Features 18. Object Types19. Nested Tables and VARRAYs20. Object Views21. External Procedures
Part VI: Making PL/SQL Programs Work 22. Code Design Tips23. Managing Code in the Database24. Debugging PL/SQL25. Tracing PL/SQL26. Tuning PL/SQL
Part VII: Appendixes A. What's on the Companion Disk?B. Calling Stored Procedures from PL/SQL Version 1.1C. Built-in Packages


Want to learn more information about Oracle PL/SQL Programming?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Oracle Database 10g PL/SQL Programming Review

Average Reviews:

(More customer reviews)Are you looking to buy Oracle Database 10g PL/SQL Programming? Here is the right place to find the great deals. we can offer discounts of up to 90% on Oracle Database 10g PL/SQL Programming. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Oracle Database 10g PL/SQL Programming ReviewThe book is a large survey of the PL/SQL language and introduces many new things that have changed with 10g. But there is a major problem with the book, which runs throughout almost all Oracle Documentation.
The book is written more as a corporate training manual than that of a programming text book. As probably everyone who ever took a training class from their company knows, training is often done by people who not only are not educators, but may not actually understand or have even used the subject of the training. It is intentional that such people do not state the concepts abstractly - they only know concrete examples and maybe only the example in their pre-written material.
This book fits this description to a T. It does not specify the correct syntax except in examples. It does not specify the qualifications and conditions governing the language elements or the examples. As such, unless you are essentially copying an example almost verbatim, you have no real knowledge of whether your code will compile, let alone work as intended. As an example consider their discussion of SELECT statements. They speak about the Select clause, the INTO clause, etc. Nowhere do they state that the list of items in the INTO clause should separated by commas. Although most people could correctly guess that the comma is the separator, you need to find an example to show you that. The book is rampant with omissions like this. Two pages later, they use an OPEN - FOR construct in an example without introducing it. That it can be used dynamically, i.e. with the query in a character string constructed at run time, is not only not mentioned in this section, but is not even mentioned in the chapter on Dynamic SQL.
This should be looked upon as a book of (simple) examples. It should be no one's text or reference.Oracle Database 10g PL/SQL Programming OverviewCreate dynamic client/server applications using PL/SQL and the comprehensive information contained in this authoritative volume. Expert Oracle insiders cover the features of PL/SQL, explain scripting semantics and syntax, and fully detail the PL/SQL functionality of Oracle Database 10g. You'll learn how to write powerful PL/SQL programs, interact with Oracle databases, perform complex calculations, and handle error conditions.

Want to learn more information about Oracle Database 10g PL/SQL Programming?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Mastering Oracle PL/SQL: Practical Solutions Review

Average Reviews:

(More customer reviews)Are you looking to buy Mastering Oracle PL/SQL: Practical Solutions? Here is the right place to find the great deals. we can offer discounts of up to 90% on Mastering Oracle PL/SQL: Practical Solutions. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Mastering Oracle PL/SQL: Practical Solutions ReviewI've had this book for a couple of months now. I've been waiting to finish it before writing a review, but it doesn't look like I'll be finished with it any time soon mostly because I'm using it as a reference book instead of reading it from front to back.
Clearly the book wasn't written as a reference book. Just look up almost any topic in the index and you'll find a number of entries scattered all over the place. Pipe-lined functions, for example, are written about in 4 (four) separate chapters! But the index is good and the material isn't redundant. The reason for this strange structure, I think, is as follows:
The book is divided into two equal length sections. The first half deals in general with PL/SQL strategies and techniques: how to check your code for efficiency, why code should be in packages, how to use cursors, cursor variables, cursor expressions, anchored data types and collections. The second half of the book re-visits most of the same topics in an application centric way (often using PL/SQL supplied packages). It's natural that some of the same techniques and strategies will be re-used and there will be some overlap in the application-oriented chapters.
Sometimes though, the repetition is weird: both the trigger chapter and the security chapter describe a logon trigger that's designed to prevent an ODBC user from accessing the database. The security chapter discusses the data base object grants that are necessary for the trigger to work while the trigger chapter omits all this. The trigger chapter discusses the security risk with the trigger, how a user can often rename the desktop application and bypass the trigger's intent (and purpose) while the security chapter doesn't mention that problem at all.
The book's style (but not its (lack of) organization) is clearly influenced by Tom Kyte's writing, (one of the technical reviewers). Each proposition, especially in the first 1/2 of the book is backed up with a SQL proof/example/argument (based usually on the v$stat view). The style is taken to the max in the discussion of implicit vs. explicit cursors, (in chapter 3). There the discussion stretches over 10 pages and alternates between thesis anti-thesis proof and counter proof like a debate in a Tibetan monastery.
A nice thing is that there's often more than one solution to a problem. For example the code that monitors the Oracle alert file for error messages opens the alert file as an EXTERNAL TABLE, but then an alternate approach is described, which opens the alert file as a BFILE (an external LOB). This is coupled with an explanation about why you might want to go one way or the other, which is very illuminating (although in this specific case, I'm not sure why the author didn't simply open the alert file using utl_file supplied package.)
In my opinion, the chapter describing the PL/SQL Web Toolkit and related technologies is a treasure trove by itself and probably worth the price of the whole book. I don't believe this information is available in such an engaging lucid way anywhere else. It's the only chapter that I had read without stopping.
The book came out as Oracle10g was being released, which raises an important question - is this book already outdated or not? My feeling is that the book is just relevant for 10g PL/SQL developers as 9i developers. The reason I say this is that the PL/SQL language from the developer's point of view has not changed between 9i and 10g (See the paper on OTN 'What's New in PL/SQL in Oracle Database 10g?' which emphasizes that the main changes in PL/SQL 10g - compiler and execution environment - are transparent to the developer.) Maybe, for 10g, the book could have mentioned some of the new PL/SQL supplied packages, for example, dbms_scheduler in addition to dbms_job, or utl_mail instead of utl_smtp, htmldb in addition to the web toolkit, but obviously this has no impact on the book's main message.
What is the book's main message? Demonstrate that the PL/SQL code you write is performant and scalable (chapter 1). The rest of the book is a hodgepodge of technical PL/SQL advice and techniques that should have been organized like a dictionary or an encyclopedia. But nothing is perfect and you can still learn a lot from this eccentric PL/SQL text (even if you can't read it from cover to cover).Mastering Oracle PL/SQL: Practical Solutions OverviewPL/SQL is the procedural programming language of choice in the Oracle database. It is completely integrated with SQL and is the most fully optimized, highest performance language for database transaction processing.This book is about cool, effective techniques to solve essential problems using PL/SQL. It does not attempt to teach the language - there are plenty on the market that do that - instead it focuses in on the fundamental programming unit, the stored procedure, and demonstrates how to code them in the most effective manner and on real practical uses for them in the database.In short: if you have mastered the fundamentals of the PL/SQL language, and are now looking for an in-depth, practical guide to solving real problems with PL/SQL stored procedures, then this is the book for you. It will demonstrate how to:- Design efficient, high performance PL/SQL code - Implement effective data handling mechanisms - Streamline your database administration - Work with Triggers - Secure your data - Build effective web applications that run from the database - Exploit the versatile functionality of Java right in the database- Debug and optimize PL/SQL This book is targeted primarily at the Oracle DBA or developer charged with the implementation of effective data handling and database administration mechanisms, but will also have great appeal to any developer whose applications rely on an Oracle database and who needs a sound understanding of how to use PL/SQL in order to distribute their application code effectively.

Want to learn more information about Mastering Oracle PL/SQL: Practical Solutions?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide) Review

Average Reviews:

(More customer reviews)Are you looking to buy Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide) ReviewThere are always 2-3 books every developer has in their area of expertise and if you're using PL/SQL, the Feuerstein book is one of them.
I'm not sure how much someone can get out of it if they never did work coding before and you're trying to learn it but I can think of many many times I needed an example for a specific problem and the book had a great example of how to do it.
Also I warn people to be careful because especially for the later chapters, they evolve to the answer to the problem and the cognitive method for this book is to follow along to the end to see how it got there - I think to some of the reviewers this is verbose but this really sinks the PL/SQL concept into your brain effectively and in my experience it's clearly worthwhile. I'm amazed (as always) how clear the evolution is if you take the time to follow it.
I might also add if you're not doing PL/SQL for work but trying to learn it, the evolution might not make sense it's very obvious to me the author has hard core real experience to approach the topics the way he does it.
For people in the field, I'd even say if you're a brand new developer on a job or programmed in something else and are approaching PL/SQL for the first time, the examples are more than clear enough and the opening chapters cover relatively universal and simple concepts so I believe the book is extremely beneficial for beginners as well as very advanced PL/SQL developers.Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide) Overview
This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website. This indispensable reference for both novices and experienced Oracle programmers will help you:



Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code
Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition
Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture
Understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new CONTINUE statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL
Use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects
Build modular PL/SQL applications using procedures, functions, triggers, and packages


Want to learn more information about Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...