Oracle PL/SQL Best Practices Write the Best PL/SQL Code of Your Life

Name: Oracle PL/SQL Best Practices Write the Best PL/SQL Code of Your Life
Price: 2.76 USD
Availability: InStock
ISBN: 9780596514105

ISBN-10: 0596514107

ISBN-13: 9780596514105

Edition: 2nd 2008 (Revised)

Authors: Steven Feuerstein

List price: $29.99

30 day, 100% satisfaction guarantee!

Buy new: $21.82

Marketplace

4 new & used from $2.76

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

In this compact book, Steven Feuerstein, widely recognized as one of the world's leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications. Covering the latest Oracle release, Oracle Database 11g, Feuerstein has rewritten this new edition in the style of his bestselling Oracle PL/SQL Programming . The text is organized in a problem/solution format, and chronicles the programming exploits of developers at a mythical company called My Flimsy Excuse, Inc., as they write code, make mistakes, and learn from those mistakes-and each other. This book…

Book details

List price: $29.99
Edition: 2nd
Copyright year: 2008
Publisher: O'Reilly Media, Incorporated
Publication date: 11/13/2007
Binding: Paperback
Pages: 292
Size: 5.98" wide x 9.13" long x 0.61" tall
Weight: 1.144

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Programming: Guide to Oracle8i Features, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly & Associates). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992.



Preface



The Big Picture


Successful Applications Are Never an Accident


Best Practices for Successful Applications



Real Developers Follow Standards


Best Practices for Developing and Using Standards



Life After Compilation


Testing, Tracing, and Debugging


Best Practices for Testing, Tracing, and Debugging



What's Code Without Variables?


Best Practices for Declaring Variables and Data Structures


Best Practices for Using Variables and Data Structures


Best Practices for Declaring and Using Package Variables



Developer As Traffic Cop


Best Practices for Conditional and Boolean Logic


Best Practices for Loop Processing


Best Practices for Branching Logic



Doing the Right Thing When Stuff Goes Wrong


Best Practices for Understanding Error Handling


Best Practices for Nitty-Gritty, Everyday Exception Programming


Best Practices for Coding Defensively



Break Your Addiction to SQL


SQL Is Bad!


General SQL Best Practices


Best Practices for Querying Data from PL/SQL


Best Practices for Changing Data from PL/SQL


Best Practices for Dynamic SQL



Playing with Blocks (of Code)


Best Practices for Parameters


Best Practices for Procedures and Functions


Best Practices for Packages


Best Practices for Triggers



My Code Runs Faster Than Your Code


Best Practices for Finding Slow Code


Best Practices for High-Impact Tuning


Best Practices for Other Tuning



Best Practices Quick Reference



Resources for PL/SQL Developers


Index