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:
<ul>
<li>How should I format my code?</li>
<li>What naming conventions, if any, should I use?</li>
<li>How can I write my packages so they can be more easily maintained?</li>
<li>What is the most efficient way to query information from the database?</li>
<li>How can I get all the developers on my team to handle errors the same way?</li>
</ul>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.

Oracle PL/SQL Best Practices

Computers & Technology

Feuerstein, Steven

Programming Languages

O'Reilly Media

Pl/Sql, Oracle's programming language for stored procedures, delivers a world of possibilities for your database programs. Pl/Sql supplements the standard relational database language, Sql, with a wide range of procedural features, including loops, If-Then statements, advanced data structures, and rich transactional control-all closely integrated with the Oracle database server. Knowing where to start with Oracle's procedural language is not always obvious to a newcomer, especially considering the language's feature set and the sheer size of the official documentation (not to mention Oracle's ever-increasing number of pre-built Pl/Sql programs). But Learning Oracle Pl/Sql offers the signposts and guidance you need to come up to speed on the language, delivered in a manageable number of pages while covering all the essentials. Topics include: Pl/Sql-what is it, and why use it? Why use Pl/Sql instead of Java? Syntax and examples of all core language constructs Creating, using, and reusing stored procedures, functions, and packages Building web-based applications using Pl/Sql features available "out of the box" (such as Pl/Sql Server Pages) Securing Pl/Sql programs against attack Benefits of third-party developer tools and integrated development environments Connecting Pl/Sql to email, Java, and the Internet Meticulously crafted with all-new examples downloadable from examples.oreilly.com/learnoracle, the book addresses language features available in all versions of Oracle, from Oracle7 to Oracle8i to Oracle9i. Learning Oracle Pl/Sql was written by Pl/Sql experts Bill Pribyl and Steven Feuerstein, whose easy-to-read style and attention to detail has made other O'Reilly books (such as the bestselling Oracle Pl/Sql Programming ) very popular among Oracle developers worldwide. Learning Oracle Pl/Sql is meant for a wide range of target audiences, including both beginning programmers and those already experienced with ot

Learning Oracle PL/SQL: Oracle Development Languages

Pribyl, Bill

Nearly a quarter-million PL/SQL programmers--novices and experienced developers alike--have found the first and second editions of Oracle PL/SQL Programming to be indispensable references to this powerful language. Packed with examples and recommendations, this book has helped everyone, from Oracle Forms developers to database administrators, make the most of PL/SQL. This new edition is a comprehensive update of the original book, covering all versions of PL/SQL through Oracle9i Release 2. It adds much-requested new chapters on how to create and run PL/SQL programs, call Java methods from within PL/SQL, and define and use database triggers. An extensive new chapter--designed especially for experienced PL/SQL developers--describes PL/SQL's runtime architecture and how to use knowledge of Oracle internals to get the best performance from PL/SQL.The book contains information about the latest Oracle9i PL/SQL features, including:
<ul>
<li>Record-based DML: You can now use records in INSERT and DELETE statements.</li>
<li>Table functions: These are functions that return a result set (in the form of a PL/SQL collection). Such functions existed in Oracle8i but they are now much expanded.</li>
<li>New and improved datatypes: Oracle now offers dramatically improved support for timestamps, time zone management, and interval calculations. In addition, the XMLType datatype has now been implemented.</li>
<li>Inheritance for object types: You can now define a hierarchy of object types (which were first introduced in Oracle8). </li>
<li>Enhancements to PL/SQL collections. PL/SQL now supports multiple-level collections (nesting collections withincollections), as well as associative arrays (previously called index-by tables), which allow you to index by PLS_INTEGER and VARCHAR2.</li>
<li>Native compilation of PL/SQL code: PL/SQL source code can now optionally be compiled into native object code that is linked into Oracle. </li>
</ul>The book is divided into six parts:<ul>
<li>Part I, Programming in PL/SQL </li>
<li>Part II, PL/SQL Program Structure </li>
<li>Part III, PL/SQL Program Data </li>
<li>Part IV, SQL in PL/SQL</li>
<li>Part V, PL/SQL Application Construction</li>
<li>Part VI, Advanced PL/SQL Topics</li>
</ul>Even if you've been a PL/SQL developer for years, you'll find an enormous amount of new and revised information in this third edition and on its companion web site. If you're new to PL/SQL, you'll find Oracle PL/SQL Programming an invaluable companion on the road to mastery.

Oracle PL/SQL Programming, Third Edition

Pl/Sql, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, Pl/Sql has also become an essential tool for database administration, as Dbas take increasing responsibility for site performance and as the lines between developers and Dbas blur. Until now, there has not been a book focused squarely on the language topics of special concern to Dbas Oracle Pl/Sql for Dbas fills the gap. Covering the latest Oracle version, Oracle Database 10g Release 2 and packed with code and usage examples, it contains: A quick tour of the Pl/Sql language, providing enough basic information about language fundamentals to get Dbas up and running Extensive coverage of security topics for Dbas: Encryption (including both traditional methods and Oracle's new Transparent Data Encryption, Tde); Row-Level Security (Rls), Fine-Grained Auditing (Fga); and random value generation Methods for Dbas to improve query and database performance with cursors and table functions Coverage of Oracle scheduling, which allows jobs such as database monitoring and statistics gathering to be scheduled for regular execution Using Oracle's built-in packages (Dbms_Crypto, Dbms_Rls, Dbms_Fga, Dbms_Random, Dbms_Scheduling) as a base, the book describes ways of building on top of these packages to suit particular organizational needs. Authors are Arup Nanda, Oracle Magazine 2003 Dba of the Year, and Steven Feuerstein, the world's foremost Pl/Sql expert and coauthor of the classic reference, Oracle Pl/Sql Programming. Dbas who have not yet discovered how helpful Pl/Sql can be will find this book a superb introduction to the language and its special database administration features. Even if you have used Pl/Sql for years, you'll find the detailed coverage in this book to be an invaluable resource.

Oracle PL/SQL for DBAs: Security, Scheduling, Performance & More

Nanda, Arup

While it's good to have a book with all the answers--like your trusty copy of Oracle PL/SQL Programming-- how often do you need all the answers? More likely, you just need a reminder, a quick answer to a problem you're up against. For these times, nothing's handier than the new edition of the Oracle PL/SQL Language Pocket Reference by PL/SQL experts Stephen Feuerstein, Bill Pribyl, and Chip Dawes. Newly updated for Oracle10g, this little book is always at the ready for the quick problem solving you need.The 3rd edition of this popular mini-reference boils down the most vital information from Oracle PL/SQL Programming into a handy guide to PL/SQL basics. The book includes fundamental language elements, such as block structure, identifiers, variables, datatypes, ad declarations; statements for program control, cursor management, and exception handling; the basics of records, procedures, functions, triggers, and packages; and the calling of PL/QL functions in SQL.And there's more. This concise guide also covers Oracle objects, collections, external procedures, Java integration, and new Oracle 10g elements like regular expressions, compile-time warnings, more implicit conversion, FORALL support for non-consecutive indexes, and more. The amount of valuable information packed into this slim volume--intelligently arranged for quick accessibility--make this an indispensable reference for new and seasoned Oracle database developers alike.O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and need to get to a solution quickly, the 3rd edition of Oracle PL/SQL Language Pocket Reference is the book you'll want to have.

Oracle PL/SQL Language Pocket Reference, 3rd Edition

Dawes, Chip

Programming

O'Reilly & Associates

For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL.
The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers.
The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization.
Co-authored by the world's foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications--making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.

Oracle PL/SQL Programming, 4th Edition

The implementation of stored procedures in MySQL 5.0 a hugemilestone -- one that is expected to lead to widespread enterprise adoption ofthe already extremely popular MySQL database. If you are serious aboutbuilding the web-based database applications of the future, you need toget up to speed quickly on how stored procedures work -- and how tobuild them the right way. This book, destined to be the bible of storedprocedure development, is a resource that no real MySQL programmer canafford to do without. In the decade since MySQL burst on the scene, it has become thedominant open source database, with capabilities and performancerivaling those of commercial RDBMS offerings like Oracle and SQLServer. Along with Linux and PHP, MySQL is at the heart of millions ofapplications. And now, with support for stored procedures, functions,and triggers in MySQL 5.0, MySQL offers the programming power neededfor true enterprise use. MySQL's new procedural language has a straightforward syntax, making iteasy to write simple programs. But it's not so easy to write secure,easily maintained, high-performance, and bug-free programs. Few in theMySQL world have substantial experience yet with stored procedures, butGuy Harrison and Steven Feuerstein have decades of combined expertise. In MySQL Stored Procedure Programming, they putthat hard-won experience to good use. Packed with code examples and coveringeverything from language basics to application building to advancedtuning and best practices, this highly readable book is the one-stopguide to MySQL development. It consists of four major sections:
<ul>
<li>MySQL stored programming fundamentals -- tutorial, basicstatements, SQL in stored programs, and error handling</li>
<li>Building MySQL stored programs -- transaction handling,built-in functions, stored functions, and triggers</li>
<li>MySQL stored programs in applications -- using storedprograms with PHP, Java, Perl, Python, and .NET (C# and VB.NET)</li>
<li>Optimizing MySQL stored programs -- security, basic andadvanced SQL tuning, optimizing stored program code, and programmingbest practices</li>
</ul>
A companion web site contains many thousands of lines of code, that youcan put to use immediately.
Guy Harrison is Chief Architect of Database Solutions at Quest Softwareand a frequent speaker and writer on MySQL topics. Steven Feuerstein isthe author of Oracle PL/SQL Programming, the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.

MySQL Stored Procedure Programming: Building High-Performance Web Applications in MySQL

Harrison, Guy

Web Development & Design

The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming.
This concise guide boils down the most vital PL/SQL information into an accessible summary of:
<ul>
<li>Fundamental language elements (e.g., block structure, datatypes, declarations)</li>
<li>Statements for program control, cursor management, and exception handling</li>
<li>Records, procedures, functions, triggers, and packages</li>
<li>Calling PL/SQL functions in SQL</li>
<li>Compilation options, object-oriented features, collections, and Java integration</li>
</ul>The new edition describes such Oracle Database 11g elements as PL/SQL's function result cache, compound triggers, the CONTINUE statement, the SIMPLE_INTEGER datatype, and improvements to native compilation, regular expressions, and compiler optimization (including intra-unit inlining). In addition, this book now includes substantial new sections on Oracle's built-in functions and packages.When you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration.

Oracle PL/SQL Language Pocket Reference

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: 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? 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, Pre

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

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 sequen

Oracle PL/SQL Programming

See the best price to sell, buy, or rent books by Feuerstein, Steven. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Feuerstein, Steven