|
|
Free
Oracle Utilities
Script to Transfer Source Code to
Files
Author: Dan Clamage, Clamage
Computer Consulting
This utility doesn't actually use dbms_sql,
but it does dynamically generate a script which dynamically generates
scripts. Dan has used it to move large numbers of compiled PL/SQL
between instances, capture code for which no source code exists, document
the existing program state for a schema, etc. He found it very handy, and
interesting to write. Click
Here for Dan's utility.
Win a Free Cap! Donate useful
code to the Pipeline Library, and we will mail you a "stylin"
embroidered RevealNet baseball cap if your utility is published in the newsletter.
Just submit your code archive to cwhite@revealnet.com
|
Tips of the Month
DB2 Tip of the Month
When
to Create and Build Indexes
|
| Discussions of the Month
RevealNet's "Pipe Talk" forums are rich in technical discussions.
Each month, we review the conferences for especially interesting discussion
topics. Log on to "Pipe Talk" to view discussions and share
technical ideas with your colleagues around the world.
- Oracle DBA Pipeline
Conference: Performance & Tuning
Subject: "Choose Cost or Rule Based Optimizer?"
Pipeliners discuss the pros and cons of CBO vs. RBO utilization.
- PL/SQL Pipeline
Conference: Best Practices
Subject: "Formatting Dynamic SQL"
Pipeliners Darryl Hurley, Dan Clamage, James Padfield and others discuss best
practices for formatting Dynamic SQL. The outcome of this discussion will
be published in Steven Feuerstein's next book.
|
| Pipeliner of the Month:
Daniel Clamage
Dan Clamage first logged on to the RevealNet
Pipelines in September 1997 and has since been one of the most active
contributors on our forums. His postings add significant content,
substance, and humor to Pipe Talk discussions. Dan is President of Clamage
Computer Consulting, a Pittsburgh-based Oracle consulting company.
Visit Dan's website for useful PL/SQL code and papers.
|
Win
a FREE Cap!!
We love getting white papers, tips, articles
and code examples/archives from our readers around the world. Send
your submission to cwhite@revealnet.com.
If your article is published, we will mail you a "stylin'"
RevealNet baseball cap as a gesture or our appreciation.
Our mission at RevealNet is to anticipate the
daily responsibilities and challenges faced by database professionals.
Our products help thousands of people solve problems and implement solutions
every day. This newsletter is designed to help facilitate the sharing
of information among database professionals. It is currently
circulated to 17,000 readers.
|
| Editor's
Note A Moment to Say Thanks
The RevealNet Pipeline Communities are now entering their fifth
year. The inspiration behind the pipelines in 1996 was multi-fold:
- To provide a commercial-free environment for the pure exchange of
technical ideas, code and papers among Oracle professionals worldwide
- To provide a landing place on the internet for members of Compuserve's
ORAUSER and ORASUPPORT forums, which were slowly starting
to fade out of existence
- Research. The Pipelines are an excellent vehicle to help us
find out what people are really talking about in the Oracle
world. The existence of the Pipelines makes our Knowledge Bases
and Development Tools the best of their kind in the industry.
Many thanks to Mike Ault, Steven Feuerstein, John Beresniewicz and the
thousands of Pipeliners who believed in this idea and helped make the
project a success. Special thanks also go to RevealNet's Christina
Gilsbach whose superb technical publishing skills and ideas always make
this newsletter look its best. A couple of facts about the
Pipelines:
- Over 21,000 free registered members
- Average number of visitors per day: 500
- New Pipeline Members per day: 20
- Heavy Message Volume - The Pipelines have the greatest amount of
daily message volume compared with other Oracle-related web sites
(with the exception of OTN, MetalLink and usenet).
- The popularity of the Pipelines helped place RevealNet in the top 4
percent of the most-linked websites (source: Websmostlinked.com).
The Pipelines have evolved into a virtual club for database
professionals worldwide. It is very gratifying to see the enthusiasm
and support professionals lend one another every day.
Finally, 2001 will bring exciting new additions to the RevealNet family
of products. Please make sure to join the Pipelines and subscribe to
this Newsletter to get the latest information. As always, we welcome
your comments, feedback and suggestions to help better serve your needs.
Sincerely,
Cam White
Pipeline Newsletter Editor
DBA World Tour 2001
RevealNet author Mike Ault will be
traveling around the world next year with Oracle authors Robert Freeman,
Marlene Theriault, Don Burleson, David Ensor and Debbie Wong. In addition
to several U.S. destinations, the group will be conducting 2-day seminars
in the following international locations:
Monterrey, Rome, Prague, Santiago, Buenos
Aires, Copenhagen, Vienna, London, Paris, Madrid, Frankfurt, Sao Paulo,
and Lima. Click here for more
information, schedules and costs.
RevealNet Contact Info
RevealNet, Inc.
P.O. Box 5560
Rockville, MD 20855
Tel: 800-738-3254 Toll-Free US
Tel: 301-947-7744 International
Fax: 301-947-9610
Email: info@revealnet.com
|
| About
RevealNet
RevealNet develops Knowledge Bases and Development Tools for
Oracle and DB2 professionals. Our Knowledge Bases are designed to anticipate the daily challenges of DBAs and Developers -
providing the background information, syntax and examples you need to apply solutions immediately. Our Oracle development tools
help you write far less code, improve code maintainability and achieve development excellence.
About the Newsletter
This newsletter is distributed to RevealNet customers, prospects and friends who have subscribed to it from our website. If you would like to unsubscribe, please send a note to info@revealnet.com and we will make every effort to remove you from our list. Subscribe a Friend!
Do you know someone who would like to receive the RevealNet Pipeline Newsletter? If so, please enter their email address in the box below and click SUBMIT.
|
|
|
 | Managing
Oracle 8i Temporary Tables
By
Vijays, Datacons |
A temporary table has a definition or
structure that persists like that of a regular table, but the data it
contains exists only for the duration of a transaction or session.
Oracle8i allows you to create temporary tables to hold session-private
data. You specify whether the data is specific to a session or to a
transaction. Click Here for the
paper.
|
Triggers are a powerful feature of DB2 for
OS/390. They enable non-bypassable, event-driven logic to be
intrinsically intermingled with data. The following guidelines can be
used to help you implement effective and efficient triggers for your DB2
databases and applications. Click Here for the
topic.
We're giving away a Free IDUG 2001 - North
America Conference Registration. Don't be the only one not going --
Click Here for information on this great contest!
|
|
When writing Production-quality software,
take the attitude of making all your code bullet-proof right up front, the
first time through coding (instead of thinking "I'll add it
later"). This requires a tedious amount of pessimism about your
own code. It seems like overkill while you're writing it, but it'll
really save your butt. Click Here
for the article.
Note: All articles in the Pipeline
Newsletter have been published with the written permission of their
respective authors.
|
RevealNet Product
Focus
|
 |
The Knowledge Base for
Active PL/SQL Development
Building Excellence in Your
PL/SQL Applications
|
Writing complex PL/SQL code for Oracle databases
is an art. Each decision a programmer makes carries a
consequence. Sloppy or poorly written code causes database performance
problems - resulting in extremely slow response times, database crashes and
maintenance nightmares. It is estimated that approximately 80 percent
of database performance problems can ultimately be traced to poorly-written
code. Well-written code, on the other hand, produces optimized
response times, is easier to maintain and causes far fewer nightmares.
The Knowledge Base for Active PL/SQL
Development gives developers an arsenal of tools to write the best
possible code.
Key Product Features
- Comprehensive
Knowledge Base covering the entire lifecycle of programming with the
PL/SQL language.
- PL/Vision
- a very robust Code Library of over 1,000 pre-written PL/SQL procedures
and functions. Every time PL/Vision is used developers save
themselves from writing dozens or hundreds of lines of code.
- Instant Messages for Oracle
gives developers immediate access to over 25,000 error messages across
multiple versions of Oracle (versions 7.3 - 8i).
- Stumped with a development problem?
The Knowledge Base for Active PL/SQL Development contains links to the PL/SQL
Pipeline, RevealNet's free internet community for PL/SQL developers
worldwide. "Pipe Talk" provides a rich forum for sharing
problems, bugs, solutions, code examples, etc. with PL/SQL developers
around the world.
Key Benefits to customers:
- Immediate Access to Technical
Information - No more shutting down to search for information in the
manuals or books. With just a mouse-click, the information you
need is delivered to you.
- Write Far Less Code - With
thousands of "copy-and-paste" code examples and a massive Code
Library at your fingertips, chances are pretty good that you will find
the code you need to implement solutions now.
- Stay Ahead of Schedule - With
thousands of pre-built code examples and best-practice technical
knowledge available, you can build and deploy complex PL/SQL
applications much faster than "coding from scratch."
- Build High-Quality, Optimized
Applications - RevealNet publishes technical content and code
examples written by the best available experts in the industry,
including Steven Feuerstein,
whose numerous books on Oracle PL/SQL programming are
best-sellers. Steven has a reputation for building structured,
highly reusable and highly optimized code. When you deploy the
code examples provided in the Knowledge Base, you are developing on a
foundation of excellence.
- Reduced Maintenance Costs -
Periodically, applications need to be modified, upgraded and maintained
to comply with new business requirements, or to be compatible with new
releases of Oracle. When you write high-quality, optimized
applications, it is often much easier to maintain them down the road.
|
 | Partner
Focus:
Quest Software
Knowledge Bases,
PL/Formatter Save Hours for TOADTM
and SQL NavigatorTM
Users. |
| RevealNet's
Knowledge Bases and PL/Formatter keep Quest's SQL Navigator and TOAD
customers productive by delivering technical knowledge and code examples
with just a click - without ever shutting down to do research.
Interruptions and downtime at work are not
just annoying - they are very expensive. With salaries in excess of
$50 per hour, millions of dollars are lost each year when database
professionals (and databases) are down. By just highlighting a keyword
and clicking the right-mouse button, the information you need is delivered
to your desktop. Click Here
to see diagrams of RevealNet's product integration with SQL Navigator and
TOAD. PL/Formatter formats code to pre-defined standards, checks
syntax errors offline, and provides expert coding recommendations.
Together, the Knowledge Bases and PL/Formatter help Quest Software customers
work smarter.
|
| Recent
Partner Headlines |
Did you know RevealNet Knowledge Bases and Development Tools are tightly integrated with products from these companies? Click on each logo below for more information.
Software
Developers
Reseller Partners
|
| Past
Issues of the Pipeline Newsletter |
|
|
Test Your Knowledge!
This PL/SQL "Quick Quiz" question is
from our Knowledge Base for Active PL/SQL.
You can find the answer to this question in the archive
section of the PL/SQL Pipeline page on our web site.
Q. True
or False (assume x is a variable array)?
A. The
number of rows removed by x.DELETE can be les than x.COUNT.
B.
The number of rows removed by x.DELETE will always equal x.COUNT.
C. The
number of rows removed by x.TRIM can be less than x.COUNT.
D.
The number of rows removed by x.TRIM will always equal x.COUNT.
E.
x.TRIM can change the value returned by x.FIRST.
Click Here for the Answer!
|
| |
