Library of Free PL/SQL White Papers

The following White Papers and Technical Presentations are now available in the "Archives" section of the PL/SQL Pipeline. The PL/SQL Pipeline is a FREE internet community for PL/SQL developers hosted by author and instructor Steven Feuerstein. The address is: http://www.revealnet.com/plsql-pipeline/index.htm

Global Handling in Oracle Forms
By Steven Feuerstein

This Word doc explores the limitations of GLOBAL variables in Oracle Forms and suggests the use of a package surrounding GLOBALs to allow you to upgrade to Oracle Forms 5 (in Oracle Developer Release 2) more easily. Format: Microsoft Word 6, pkzipped file, 23K.

Using Oracle7 Triggers to Implement Business Rules By Kevin Owens

Oracle triggers with PL/SQL packages provide an excellent paradigm for building server-enforced, complex business rules. This 14-page white paper contains information from RevealNet's PL/SQL Knowledge Base, and discusses the use of Oracle7 triggers to implement business rules, and suggests an approach for designing triggers.
Format: Microsoft Word 6, pkzipped file, 25K.

The Psychology of is_number
By Steven Feuerstein

This file contains an article I wrote exploring some of the psychology behind the search for a solution to the is_number puzzle (April's Puzzler). It also tries to draw some lessons from the experience. Format: Microsoft Word 6, pkzipped file, 16K.

The Troublesome COMMIT
By Steven Feuerstein

This document explores in great detail the issues relating to COMMIT and the way you can build a comprehensive layer around this troublesome element of the PL/SQL language.
Format: Microsoft Word 6, pkzipped file, 16K.

Scanning PL/SQL tables
By Steven Feuerstein

This zip file contains demonstrations of different ways to scan PL/SQL tables in PL/SQL 2.3.
Format: pkzipped file, 1.2K.

Write PL/SQL code within Oracle Developer/2000 By Steven Feuerstein

When Steven Feuerstein wrote his first book, he had planned to include content on Oracle Developer/2000 (this at a time when it was known as the Cooperative Development Environment or CDE). Unfortunately, he wrote WAY too much, and this content was not published. RevealNet is now making some of the information available to you through this archive. This zip file contains suggestions on how to write PL/SQL code within the Oracle Developer/2000 environment, with a focus on Oracle Forms. Please note that this material was written in 1995; some of it may be dated at this point, pkzipped file, 51K.

Powerpoint presentations

A Principled Approach to PL/SQL Development By Steven Feuerstein

Presented as paper #6 at Oracle Open World 1997, the Powerpoint presentation and Word article contained in this zip file offer a succinct treatment of some of the most important principles upon which to base your PL/SQL development efforts, pkzipped file, 55K.

An Introduction to Oracle PL/SQL
By Steven Feuerstein

This Powerpoint presentation provides an introduction to basic elements of the PL/SQL V2 language, including the block structure, syntax, datatypes and coding style suggestions.
Format: Microsoft Powerpoint 4, pkzipped file, 42K.

Expanding Your PL/SQL Horizons - An Introduction to Built-in Packages By Steven Feuerstein

This Powerpoint presentation offers an introduction to the built-in packages, with a focus on: DBMS_PIPE, DBMS_OUTPUT, DBMS_JOB, DBMS_ALERT, DBMS_UTILITY and DBMS_SQL.
Format: Microsoft Powerpoint 4, pkzipped file, 32K.

PL/SQL Packages Best Practices
By Steven Feuerstein

Steven's handouts from his presentation at Oracle Open World on PL/SQL Packages Best Practices. This document contains selected information from RevealNet's PL/SQL Knowledge Base.
Format: Microsoft Powerpoint 4, pkzipped file, 38K.

PL/SQL Best Practices (In One Hour or Less) By Steven Feuerstein

Steven's handouts from a presentation on the most important concepts of PL/SQL best practices. Covers coding in layers, crafting generic solutions, reducing code-volume, how to avoid hard-coding and streamline your decision making.
Format: Microsoft Powerpoint 4, pkzipped file, 39K.

Changing Your Life through PL/SQL Packages By Steven Feuerstein

Steven's handouts from a presentation on the benefits of implementing PL/SQL packages now so you can take advantage of Oracle8 without having to re-write your applications.
Format: Microsoft Powerpoint 4, pkzipped file, 22K.

Miscellaneous

Pages 75 & 76 of PL/SQL Advanced Techniques Presentation By Steven Feuerstein

This zip file contains pages 75 and 76 of the PL/SQL Advanced Techniques presentation which were inadvertently missing from the course materials. Format: pkzipped file, 5K.

Copyright © 1997 RevealNet, Inc. All Rights Reserved Certain names, logos, designs, titles, words, or phrases on this page may constitute trademarks, service marks, or trade names of RevealNet, Inc. or other entities and may be registered in certain Received on Thu Dec 11 1997 - 00:00:00 CET