Advanced Oracle PL/SQL: Programming with Packages

Description

Steven Feuerstein's first book,Oracle PL/SQL Programming, has become the classic reference to PL/SQL, Oracle's procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and powerful part of the PL/SQL language -- the package. The use of packages can dramatically improve your programming productivity and code quality, while preparing you for object-oriented development in Oracle technology. In this book, Feuerstein explains how to construct packages -- and how to build them the right way. His "best practices" for building packages will transform the way you write packages and help you get the most out of the powerful, but often poorly understood, PL/SQL language.

Much more than a book,Advanced Oracle PL/SQL Programming with Packagescomes with a PC diskette containing a full-use software companion. Developed by Feuerstein, RevealNet's PL/Vision Lite is the first of its kind for PL/SQL developers: a library of thirty-plus PL/SQL packages. The packages solve a myriad of common programming problems and vastly accelerate the development of modular and maintainable applications.

The packages provided in PL/Vision Lite fall into three categories:

• Building block packages: low-level development enhancers, including string parsers, a list manager, and an interface to PL/SQL tables.
• Developer utilities: programs that improve your PL/SQL development environment, including a code generator, a powerful substitute for SHOW ERRORS, and an online help delivery mechanism.
• Plug-and-play components: pieces of code that can be used as is in your own applications, including a high-level exception handler mechanism and a generic, reusable logging mechanism.

In addition to describing the details of these packages, this book explores why and how they were built the way they were. You'll come away with an increased appreciation of the PL/SQL language and the power of packages. Most importantly, you'll be ready and eager to put that power to use immediately in your own applications.

Get the book

Amazon.com

Search the book

eBay.com

Search the book

Similar books

• 

  Oracle Advanced PL/SQL Developer Professional Guide

  By Saurabh K. Gupta

  This book is also an ideal guide for all the Associate level PL/SQL programmers who are preparing for the Professional 1Z0-146 certification. This book assumes you have prior knowledge of PL/SQL programming.

• 

  Advanced Oracle PL/SQL Developer's Guide

  By Saurabh K. Gupta

  Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c About This Book Learn advanced application development features of Oracle Database 12c and prepare for the 1Z0 ...

• 

  Advanced Oracle PL/SQL Developer's Guide - Second Edition

  By Saurabh K. Gupta

  The book has been reviewed by Oracle ACEs Kamran Agayev, Ronald Rood, Mohan Dutta, and Marcel Hoefs. The book covers the advanced features of PL/SQL which are required to design and optimize the PL/SQL code in database applications.

• 

  Advanced Plsql Programming: The Definitive Reference

  By Boobal Ganesan

  This book takes complex technical tasks and explains them in an easily understandable method.

• 

  Oracle PL/SQL Programming

  By Steven Feuerstein, Bill Pribyl

  If you're working with multibyte character sets , it matters which function you use in any given situation . When using Unicode , you have even more character function variations to learn about . Code points and code ...

• 

  Learning Oracle PL/SQL

  By Steven Feuerstein, Bill Pribyl

  "Learning Oracle PL/SQL" introduces PL/SQL in a way that's useful to a variety of audiences: beginning programmers, new Oracle database administrators, and developers familiar with other databases who now need to learn Oracle.

• 

  Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c

  By Steven Feuerstein, Bill Pribyl

  Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle’s powerful procedural language.

• 

  Oracle PL/SQL Programming: A Developer's Workbook

  By Steven Feuerstein, Andrew Odewahn

  Written by one of the world's leading experts on the Oracle PL/SQL language, this text offers extensive exercises in all skill levels covering major features of the language. Also provides a primer to the PL/SQL language.

• 

  Oracle PL/SQL Language Pocket Reference: A Guide to Oracle's PL/SQL Language Fundamentals

  By Chip Dawes, Steven Feuerstein, Bill Pribyl

  Provides quick-reference information that will help you use Oracle's PL/SQL languange, including the newest Oracle Database 10g features. This is a companion to Steven Feuerstein and Bill Pribyl's Oracle PL/SQL Programming.

• 

  Oracle PL/SQL Best Practices: Optimizing Oracle Code

  By Steven Feuerstein

  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 ...