• Complain

Steven Feuerstein - Oracle PL SQL Best Practices, 2nd Edition

Here you can read online Steven Feuerstein - Oracle PL SQL Best Practices, 2nd Edition full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2007, publisher: OReilly Media, genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

No cover
  • Book:
    Oracle PL SQL Best Practices, 2nd Edition
  • Author:
  • Publisher:
    OReilly Media
  • Genre:
  • Year:
    2007
  • Rating:
    3 / 5
  • Favourites:
    Add to favourites
  • Your mark:
    • 60
    • 1
    • 2
    • 3
    • 4
    • 5

Oracle PL SQL Best Practices, 2nd Edition: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "Oracle PL SQL Best Practices, 2nd Edition" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

In this compact book, Steven Feuerstein, widely recognized as one of the worlds 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 11gR2, 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 offers practical answers to some of the hardest questions faced by PL/SQL developers, including:What is the best way to write the SQL logic in my application code?How should I write my packages so they can be leveraged by my entire team of developers?How can I make sure that all my teams programs handle and record errors consistently? Oracle PL/SQL Best Practices summarizes PL/SQL best practices in nine major categories: overall PL/SQL application development; programming standards; program testing, tracing, and debugging; variables and data structures; control logic; error handling; the use of SQL in PL/SQL; building procedures, functions, packages, and triggers; and overall program performance. This book is a concise and entertaining guide that PL/SQL developers will turn to again and again as they seek out ways to write higher quality code and more successful applications. This book presents ideas that make the difference between a successful project and one that never gets off the ground. It goes beyond just listing a set of rules, and provides realistic scenarios that help the reader understand where the rules come from. This book should be required reading for any team of Oracle database professionals. --Dwayne King, President, KRIDAN Consulting

Steven Feuerstein: author's other books


Who wrote Oracle PL SQL Best Practices, 2nd Edition? Find out the surname, the name of the author of the book and a list of all author's works by series.

Oracle PL SQL Best Practices, 2nd Edition — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Oracle PL SQL Best Practices, 2nd Edition" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

Reset

Interval:

Bookmark:

Make
Oracle PL/SQL Best Practices, 2nd Edition
Steven Feuerstein
Editor
Debby Russell
Editor
Mary Treseler

Copyright 2009 Steven Feuerstein

OReilly Media Dedication To the many PLSQL programmers around the world - photo 1

O'Reilly Media

Dedication

To the many PL/SQL programmers around the world who have enriched my life and made PL/SQL the amazing success that it is.

A Note Regarding Supplemental Files

Supplemental files and examples for this book can be found at http://examples.oreilly.com/9780596514105/. Please use a standard desktop web browser to access these files, as they may not be accessible from all ereader devices.

All code files or examples referenced in the book will be available online. For physical books that ship with an accompanying disc, whenever possible, weve posted all CD/DVD content. Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to .

Preface

I love getting started on new projects (and I include working on new editions of existing books in that general category). It is the perfect opportunity to say to myself: "I am going to get it right this time!"

That fantasy usually persists only for days (or maybe weeks) into a project before it fades, but in the case of the second edition of Oracle PL/SQL Best Practices , I managed to live out my fantasy all the way through. You are holding the result in your hands, and I hope you enjoy reading and learning from it as much as I enjoyed writing it.

Here's how I managed this remarkable feat: I took a vow to not let best practices get boring.

Now, don't get me wrong. I liked the first edition of this book, and so did its many readers. Yet in hindsight, I feel as if I took a right turn when I should have kept going straight. My first book, Oracle PL/SQL Programming , has been extremely popular over the years, and many people have told me how much they like the sense of humor, the anecdotes, and the many detailed examples.

Several years after the publication of Oracle PL/SQL Programming , I wrote Oracle PL/SQL Best Practices . And somehow, for reasons I cannot recall, I managed to make this book a somewhat preachy and rigidly structured text. Luckily for me, developers seem to like lots of structure and don't mind too much being preached at by people they trust!

But as I considered revamping this book for its second edition, I found myself thinking: best practices are really important, but that doesn't mean they have to be seriousthey can be fun and entertaining (as much for me to write as for you to read)!

So that's what I did: I had fun writing this book. I sacrificed some of the rigidity of structure, emphasized practicality over theoretical usefulness, and generally came down off my perch (don't worrythere are still more than enough rants and soapboxing!). In this second edition, I've tried to make the discussion a lot more interesting by sharing many of my ideas about best practices through stories about the successes and failures of the employees of the fictitious company, My Flimsy Excuse, Inc., and the adventures of its development team (the members of the team are described later in the Preface). Of course, I have also updated the text to keep pace with Oracle Corporation's implementation of new PL/SQL features, including those in Oracle Database 11 g .

Why Best Practices?

My intention with this book is to provide you with a set of best practices guidelines for building programs and applicationsthat will improve (and, I hope, transform ) the PL/SQL code you write. Some of these best practices are high-level recommendations for how to approach designing and writing your overall applications. Other best practices are much more oriented to day-to-day programming practice. In most of my recommendations, I include references to code or tools that you can download that will make it easier for you to apply these recommendations.

, The Big Picture , covers the high-level recommendations for writing high-quality code. The remaining chapters of the book explore how to apply specific guidance to the everyday realities of software development. Before we delve into these specific recommendations, though, I would like to take advantage of this Preface to offer some thoughts on the role of software developersand the nature of our jobsin the big, wide world "out there" beyond our code.

Best Practices and the Real World

Clearly, software developers want to (and should) pay attention to best practices so that they will be able to create more successful applications. I also believe, however, that the responsibility of developers goes well beyond the specific projects on which they are working.

After all, you are one of the people who make software possible , who therefore make computer systems like the Internet possible. That is an awesome amount of power, but as Spider Man's uncle tells us, "With great power comes great responsibility."

From this perspective, it is very important to understand that you are not just a cog in the corporate wheel. When you are told to write a program, you should engage fully with that request. You should make sure not only that you understand in detail what it is the user wants you to write, but also that you appreciate how this program will meet its business objectives.

As a programmer, you are trained to think logically about the challenges in front of you. This rational thought process is not something to be taken for granted. Many other humans have never received such training and don't know how to reason their way through complex and thorny problems. Given this background, you can often help your users more clearly understand their own roles and their own challenges.

Your responsibility also extends beyond business objectives. You have an ethical responsibility to make sure that the software you write will not cause harm. Let's face it: executives of companies cannot always be trusted to do the right thing for their customers, for the company and its employees, and for society at large. Let's not forget the terrible lessons learned from Enron, Arthur Andersen, Union Carbide, Halliburton, and so many others. If you write software that enables executives in your firm to break the law or simply take advantage of those less fortunate, then you are complicit in that unethical behavior.

Of course, most of us will never be placed in such an ethical quandary. Instead, our main challenge will be to remember how much humanity depends on software, and how much we can all be hurt by buggy software, software that is not secure, and software that is simply badly designedprograms that waste the time of users and greatly increase their stress levels.

They Call This "Work"?

Can you really call what we do work ? Most people on this earth work very hard in exchange for a paycheck. They drive buses, clean sewers, work in factories, pick vegetables and fruit under a blazing sun, teach children, take care of sick peoplehard work that often takes a toll on their health and well-being. We, on the other hand... what do we do? Here are a variety of ways to characterize our "work":

Programming as poetry

We sit around in nice, air-conditioned offices or cubicles. We think about things and write them down (or type them). And for this we get a paycheck. It's like getting paid to write poetry (and some of us actually do feel that our programs are a form of poetry).

Next page
Light

Font size:

Reset

Interval:

Bookmark:

Make

Similar books «Oracle PL SQL Best Practices, 2nd Edition»

Look at similar books to Oracle PL SQL Best Practices, 2nd Edition. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.


Reviews about «Oracle PL SQL Best Practices, 2nd Edition»

Discussion, reviews of the book Oracle PL SQL Best Practices, 2nd Edition and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.