| CARVIEW |
Select Language
HTTP/2 302
server: nginx
date: Wed, 16 Jul 2025 07:14:12 GMT
content-type: text/plain; charset=utf-8
content-length: 0
x-archive-redirect-reason: found capture at 20090509085936
location: https://web.archive.org/web/20090509085936/https://oreilly.com/catalog/9780596514105/
server-timing: captures_list;dur=0.664108, exclusion.robots;dur=0.026356, exclusion.robots.policy;dur=0.011491, esindex;dur=0.014406, cdx.remote;dur=7.838035, LoadShardBlock;dur=94.766149, PetaboxLoader3.datanode;dur=43.020165
x-app-server: wwwb-app216
x-ts: 302
x-tr: 137
server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0
set-cookie: SERVER=wwwb-app216; path=/
x-location: All
x-rl: 0
x-na: 0
x-page-cache: MISS
server-timing: MISS
x-nid: DigitalOcean
referrer-policy: no-referrer-when-downgrade
permissions-policy: interest-cohort=()
HTTP/2 200
server: nginx
date: Wed, 16 Jul 2025 07:14:12 GMT
content-type: text/html
x-archive-orig-date: Sat, 09 May 2009 08:59:13 GMT
x-archive-orig-server: Apache
x-archive-orig-p3p: policyref="https://www.oreillynet.com/w3c/p3p.xml",CP="CAO DSP COR CURa ADMa DEVa TAIa PSAa PSDa IVAa IVDa CONo OUR DELa PUBi OTRa IND PHY ONL UNI PUR COM NAV INT DEM CNT STA PRE"
x-archive-orig-last-modified: Sat, 09 May 2009 00:39:01 GMT
x-archive-orig-accept-ranges: bytes
x-archive-orig-content-length: 34905
x-archive-orig-connection: close
x-archive-guessed-content-type: text/html
x-archive-guessed-charset: windows-1252
memento-datetime: Sat, 09 May 2009 08:59:36 GMT
link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="next memento"; datetime="Mon, 11 May 2009 05:14:58 GMT", Oracle PL/SQL Best Practices | O'Reilly Media
Featured customer reviews
Excellent..., December 07 2007
Oracle PL/SQL Best Practices
Steven Feuerstein
O?Reilly ? 2nd Edition
https://www.oreilly.com/catalog/9780596514105/index.html
This is a great reference for PL/SQL Programmers. The book covers most aspects of PL/SQL code from start to finish. The style used is somewhat narrative and even entertaining. The author lists several pitfalls in each chapter. The ?pitfall story? talks about why programmers might write sub-optimal code in the first place, how to recognize the problem, what is the root cause of the problem, and how to fix the problem. Each example lists code with the issue in place and then the ?patched? code after the best-practice has been implemented. Most of the example center around a database at the fictional company used to tell the stories, but the examples are forms of common issue found in most any Oracle database.
The reference does not teach the SQL language itself outside the context of PL/SQL programming. It does cover how to write better SQL in some cases and gives advice on encapsulation of SQL, packaging SQL, and auto-generating SQL. Also, best practices for how to use SQL are covered.
By following the guidelines, PL/SQL code would be easier to maintain and debug, especially for someone who did not write the code or for the developer who has not looked at the code in a while. Also, the ?best practice? code had better security feature although the author does not cover security extensively. Some of the examples of ?in-application? SQL would be vulnerable to SQL injection attacks and the recommendation by the author to encapsulate the SQL into procedures or packages mitigates this risk. The best-practice code runs more efficiently in most cases as well.
Chapters generally cover:
Overall best programming practices
Standards
Testing
Variables
Loops and Branches
Error Handling
Encapsulation of SQL
Functions and Procedures
Performance
This is an excellent reference for those who program PL/SQL.
Media reviews
"Steven Feuerstein's Oracle PL/SQL Best Practices, 2nd Edition provides the author's years of programming, teaching and writing experiences in a set of 'best practices' for developing applications...[it] is covered...in chapters which are quick and easy to consult."
-- James Cox, The Bookwatch
Read all reviews
Oracle PL/SQL Best Practices, Second Edition
Write the Best PL/SQL Code of Your Life
By Steven Feuerstein
October 2007
Pages: 292
ISBN 10: 0-596-51410-7 |
ISBN 13: 9780596514105
(Average of 1 Customer Reviews)
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.
Full 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 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:
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
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 team's programs handle and record errors consistently?
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
Featured customer reviews
Excellent..., December 07 2007
Rating:
Submitted by
jdruin
[Respond | View]
Oracle PL/SQL Best Practices
Steven Feuerstein
O?Reilly ? 2nd Edition
https://www.oreilly.com/catalog/9780596514105/index.html
This is a great reference for PL/SQL Programmers. The book covers most aspects of PL/SQL code from start to finish. The style used is somewhat narrative and even entertaining. The author lists several pitfalls in each chapter. The ?pitfall story? talks about why programmers might write sub-optimal code in the first place, how to recognize the problem, what is the root cause of the problem, and how to fix the problem. Each example lists code with the issue in place and then the ?patched? code after the best-practice has been implemented. Most of the example center around a database at the fictional company used to tell the stories, but the examples are forms of common issue found in most any Oracle database.
The reference does not teach the SQL language itself outside the context of PL/SQL programming. It does cover how to write better SQL in some cases and gives advice on encapsulation of SQL, packaging SQL, and auto-generating SQL. Also, best practices for how to use SQL are covered.
By following the guidelines, PL/SQL code would be easier to maintain and debug, especially for someone who did not write the code or for the developer who has not looked at the code in a while. Also, the ?best practice? code had better security feature although the author does not cover security extensively. Some of the examples of ?in-application? SQL would be vulnerable to SQL injection attacks and the recommendation by the author to encapsulate the SQL into procedures or packages mitigates this risk. The best-practice code runs more efficiently in most cases as well.
Chapters generally cover:
Overall best programming practices
Standards
Testing
Variables
Loops and Branches
Error Handling
Encapsulation of SQL
Functions and Procedures
Performance
This is an excellent reference for those who program PL/SQL.
Media reviews
"Steven Feuerstein's Oracle PL/SQL Best Practices, 2nd Edition provides the author's years of programming, teaching and writing experiences in a set of 'best practices' for developing applications...[it] is covered...in chapters which are quick and easy to consult."
-- James Cox, The Bookwatch
Read all reviews
©2009, O'Reilly Media, Inc. (707) 827-7000 / (800) 998-9938 All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. |
About O'Reilly
Academic Solutions Authors Contacts Customer Service Jobs Newsletters O'Reilly Labs Press Room Privacy Policy RSS Feeds Terms of Service User Groups Writing for O'Reilly |
More O'Reilly Sites
O'Reilly Radar Ignite Tools of Change for Publishing Digital Media Inside iPhone O'Reilly FYI makezine.com craftzine.com hackszine.com perl.com xml.com Partner Sites InsideRIA java.net O'Reilly Insights on Forbes.com |
Content Archive Business Technology Computer Technology Microsoft Mobile Network Operating System Digital Photography Programming Software Web Web Design |