Publisher: O'Reilly Media Released: April 2001 Pages: 208
In this book, Steven Feuerstein, widely recognized as one of the world's experts on the Oracle PL/SQL language, distills his many years of programming, writing, and teaching about PL/SQL into a set of PL/SQL language "best practices"--rules for writing code that is readable, maintainable, and efficient. Too often, developers focus on simply writing programs that run without errors--and ignore the impact of poorly written code upon both system performance and their ability (and their colleagues' ability) to maintain that code over time. Oracle PL/SQL Best Practices is a concise, easy-to-use reference to Feuerstein's recommendations for excellent PL/SQL coding. It answers the kinds of questions PL/SQL developers most frequently ask about their code: - How should I format my code?
- What naming conventions, if any, should I use?
- How can I write my packages so they can be more easily maintained?
- What is the most efficient way to query information from the database?
- How can I get all the developers on my team to handle errors the same way?
The book contains 120 best practices, divided by topic area. It's full of advice on the program development process, coding style, writing SQL in PL/SQL, data structures, control structures, exception handling, program and package construction, and built-in packages. It also contains a handy, pull-out quick reference card. As a helpful supplement to the text, code examples demonstrating each of the best practices are available on the O'Reilly web site. Oracle PL/SQL Best Practices is intended as a companion to O'Reilly's larger Oracle PL/SQL books. It's a compact, readable reference that you'll turn to again and again--a book that no serious developer can afford to be without. |
-
Chapter 1 The Development Process -
Chapter 2 Coding Style and Conventions -
Chapter 3 Variables and Data Structures -
Declaring Variables and Data Structures -
Using Variables and Data Structures -
Declaring and Using Package Variables -
Chapter 4 Control Structures -
Conditional and Boolean Logic -
Loop Processing -
Miscellaneous -
Chapter 5 Exception Handling -
EXC-00: Set guidelines for application-wide error handling before you start coding. -
Raising Exceptions -
Handling Exceptions -
Declaring Exceptions -
Chapter 6 Writing SQL in PL/SQL -
SQL-00: Establish and follow clear rules for how to write SQL in your application. -
General SQL and Transaction Management -
Querying Data from PL/SQL -
Changing Data from PL/SQL -
Dynamic SQL and Dynamic PL/SQL -
Chapter 7 Program Construction -
Structure and Parameters -
Functions -
Triggers -
Chapter 8 Package Construction -
Chapter 9 Built-in Packages -
DBMS_OUTPUT -
UTL_FILE -
DBMS_PIPE -
DBMS_ JOB -
Appendix A Best Practices Quick Reference -
The Development Process -
Coding Style and Conventions -
Variables and Data Structures -
Control Structures -
Exception Handling -
Writing SQL in PL/SQL -
Program Construction -
Package Construction -
Built-in Packages -
Colophon |
- Title:
- Oracle PL/SQL Best Practices
- By:
- Steven Feuerstein
- Publisher:
- O'Reilly Media
- Formats:
-
- Print:
- April 2001
- Ebook:
- June 2009
- Pages:
- 208
- Print ISBN:
- 978-0-596-00121-6
- | ISBN 10:
- 0-596-00121-5
- Ebook ISBN:
- 978-0-596-10347-7
- | ISBN 10:
- 0-596-10347-6
|
-
Steven Feuerstein 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. View Steven Feuerstein's full profile page. |
Colophon Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of Oracle PL/SQL Best Practices is a red wood ant. Red wood ants (Formica aquilonia) are often the dominant ants of forests throughout the northern hemisphere. F. aquilonia can build nest mounds of dried spruce needles and twigs that are three feet or more in diameter and height. Each nest can contain thousands of ants as well as several queens. The insects have no sting but can defend themselves by firing formic acid from their rear ends when disturbed. The workers vary in size up to about 1/2 inch in length with a red thorax, black abdomen, and red and black marked head. The ants are both scavengers and general predators of insects, carrying many soft-bodied caterpillars, flies, and sawflies along their several major trails back to the nest. Red wood ants are a keystone species (i.e., without them the ecosystem changes fundamentally). When red ants disappear from a system, herbivorous insects can subsequently damage forest trees. In forests weakened by pollution and acid rain in central Europe, red wood ant populations are often endangered, which in turn causes further imbalances in predator-prey dynamics and the ecosystem. These rare ants are protected by law in some European countries because of their great value in destroying forest pests. For 28 years, Professor Seigo Higashi has been studying a supercolony of Japanese red wood ants (Formica yessensis), which dwell along a strip of shoreline on the Ishikari coast of northern Japan. When first discovered in 1973, the colony consisted of approximately 45,000 nests with connecting tunnels extending nearly 12.4 miles along the shore of the Japan Sea. It was estimated that the colony had about 306 million workers and 1.1 million queens, and is thought to be about 1,000 years old. Since 1973, the colony has been under siege, threatened by the development of infrastructure for a new port on Ishikari Bay, which has occurred on top of 30% of the ant megalopolis. This has reduced the number of red wood ants living there by more than half. The Ishikari ants are one of only two known ant supercolonies in the world. The other, smaller one is in the Swiss Jura mountains. Mary Anne Weeks Mayo was the production editor, and Clairemarie Fisher O'Leary was the copyeditor for Oracle PL/SQL Best Practices. Mary Sheehan, Matt Hutchinson, and Jane Ellin provided quality control. Rachel Wheeler and Gabe Weiss provided production assistance. Ellie Volckhausen designed the cover of this book, based on a series design by Edie Freedman. The cover image is a 19th-century engraving from the Dover Pictorial Archive. Emma Colby produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font. David Futato designed the interior layout based on a series design by Nancy Priest. Clifford Dyer and Anne-Marie Vaduva converted the files from Microsoft Word to FrameMaker 5.5.6 using tools created by Mike Sierra. The text and heading fonts are ITC Garamond Light and Garamond Book. This colophon was compiled by Mary Anne Weeks Mayo. |
|
Description
|
Table of Contents
|
Product Details
|
About the Author
|
Colophon
|
 |
|
|
|
|
|
Recommended for You
|
Recently Viewed
|
|
|
By Eric A. Meyer
May 2001
By Simon St. Laurent, Joe Johnston, Edd Dumbill, Dave Winer
June 2001
By Stephen Teilhet
June 2001
|
Customer Reviews
6/18/2011 4.0Excellent books to learn Oracle PL/SQL By Kelly Blue from Sydney, Australia - Accurate
- Easy to understand
2/11/2010 (1 of 1 customers found this review helpful) By Oracletube from Austin, Tx 7/31/2003 (1 of 1 customers found this review helpful) 5.0Oracle PL/SQL Best Practices Review By David Laub from Undisclosed 11/6/2002 (3 of 3 customers found this review helpful) 5.0Oracle PL/SQL Best Practices Review By Stew Stryker from Undisclosed 6/19/2002 5.0Oracle PL/SQL Best Practices Review By RamPrasad Suswaram from Undisclosed 4/19/2002 (1 of 1 customers found this review helpful) 5.0Oracle PL/SQL Best Practices Review By Steve Kahn from Undisclosed 6/22/2001 (1 of 1 customers found this review helpful) 4.0Oracle PL/SQL Best Practices Review By John Morelock from Undisclosed 2/22/2001 4.0Oracle PL/SQL Best Practices Review By Fawwad-uz-Zafar Siddiqi from Undisclosed |
|
|
