|
|
Free
Oracle Utilities
Source
File Pre-Processing Utility
Author: Steven Baldwin
Have you ever wished you could include debug
code in your PL/SQL package, but not execute it when you have finished
debugging your package? One option is to take it all out, or comment
it all out, but for large packages this can be quite a nuisance.
Another option is to wrap all debugging code with an 'IF' statement, such as
'IF Debug THEN...', and effectively include or exclude it at run-time.
This small utility allows you to pre-process
your PL/SQL source file. It takes as input your single source file,
with sections of code wrapped by conditional expressions, using syntax
similar to the 'C' pre-processor. Click Here to get more information
and download this utility.
Win a Free Cap! Donate useful
code to the Pipeline Library, and we will mail you a "stylin"
RevealNet baseball cap if your utility is published in the newsletter.
|
Tips of the Month
DB2 Tip of the Month
Improving
Performance of the REBUILD INDEX Utility
|
| 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: Data Dictionary
Subject: "Scheduling for Analyzing Tables/Indexes"
Pipeliners discuss methods and post code for analyzing tables and indexes on a
routine basis.
- PL/SQL Pipeline
Conference: Bugs, Curiosities &
Workarounds
Subject: "Can't Drop Procedure"
Pipeliners discuss how to resolve a circular dependency between two procedures.
|
| Pipeliner of the Month:
Shripad Godbole
Shripad Godbole first logged onto RevealNet's
Pipelines in July, 1998. Since then, he has been one of our most
active contributors with almost 1,700 messages posted. Shripad lives
in Massachusetts with his wife Smita, and 2 wonderful daughters, Shepali and
Surabhi. Shripad is a Senior DBA consulting at John Hancock Financial
Services. He also enjoys bowling, table tennis and carrom. The
motto "Let's document it and call it a feature" accompanies each
of his posts on the Pipelines.
|
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.
We provide products that help DBAs and Developers solve problems and
implement solutions immediately. The Pipeline Newsletter and online
forums provide a rich, "noise-free" environment for sharing
technical ideas. This newsletter is currently distributed to 17,000
readers.
|
| Random
Notes
Thank you for Visiting with us at Oracle
Open World 2000!
Oracle Open World 2000 was a great success
for us. If you stopped by our booth, your free gift has been mailed by
now. Thanks again for your support.
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.
We've Moved! Due to expansion, the
new address for our sales office is:
RevealNet Sales Department
18401 Woodfield Road, Suite G
Gaithersburg, MD 20879
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.
|
|
|
Rollback
segments are one of the least understood areas in database tuning for many
DBAs. Most DBAs pay very little attention to tuning rollback
segments. Tuning Rollback segments requires a greater understanding of
the internal workings of Oracle and are difficult to tune by normal
means. This note gives a brief introduction to transactions and
rollback segments and goes beyond the basics of 'rollback segment is used
for transaction rollback', so the reader is familiar with what is going on
inside a rollback segment. Click Here for the paper. |
 | "44
DB2 Tips in 66 Minutes"
By
Craig Mullins, Director of DB2 Technology Planning, BMC Software |
Get out your stopwatch and review Craig's best
practices for working with DB2 in an OS/390 environment. This
presentation includes tips for RUNSTATS, REORG, Stored Procedures, Cursors
and much, much more. This Powerpoint presentation was originally
presented at IDUG 2000, and at recent user group meetings where Craig has
spoken. Click Here for the
presentation.
|
|
This powerpoint presentation is of Steven's handouts from a presentation on the
most important concepts of PL/SQL best practices. The presentation
covers coding in
layers, crafting generic solutions, reducing code-volume, how to avoid
hard-coding and streamlining your decision making. Click
Here for the presentation.
|
RevealNet Product
Focus
|
|
 | Fall
Knowledge Base Releases Now Available for Oracle and DB2
Focus on Web Development, Web
Administration, Data Warehousing |
Monday, November 13, 2000 - The Fall/Winter
v2000.2 releases of our Knowledge Bases for Oracle and DB2 are now
available. Hundreds of new topics and several new product features
have been added. To download 30-day trial versions, Click
Here.
New sections on Web Development, Web
Administration, Data Warehousing, Application Security and Oracle8i
Built-ins have been added to the Knowledge Bases for Oracle Administration and Active PL/SQL
. For a complete listing of new product enhancements,
Click Here.
Existing RevealNet customers under
maintenance will be notified via email with instructions for downloading
this latest update. If you purchased your Knowledge Bases from
Embarcadero Technologies, Quest Software or Sylvain Faust, please contact
their Support representatives for your updates.
|
Partner
Focus: Allround Automations
|
|
| Formatting
Code Inside PL/SQL Developer |
PL/Formatter, RevealNet's powerful code
formatting utility, integrates as an add-on module to Allround Automation's
PL/SQL Developer product. PL/SQL Developer is an integrated
development environment that is specifically targeted at the development of
stored program units for Oracle Databases.
PL/Formatter is a formatting utility from
RevealNet that formats PL/SQL, SQL*Plus, SQL Forms and Oracle Forms 4.5 code
to your own pre-defined standards. With the PL/Formatter Plug-In you
can use these formatting functions to easily format SQL and PL/SQL code in
PL/SQL Developer. This additionally allows you to do offline syntax
checking, profile your source code, and it can even give you coding
recommendations.
This integration only works when you purchase
the licensed version of PL/Formatter. Download a DEMO of PL/Formatter
today and try it out!
|
| 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. Which
of the following statements correctly identify the differences between strong
and weak REF CURSORs?
A. You
can use a weak REF CURSOR to declare cursor variables that can fetch rows from
any SQL statement.
B. A
strong REF CURSOR offers stronger performance and should be used whenever
possible to improve program efficiency.
C.
Using weak REF CURSORs means you have to deal more often with runtime errors, as
opposed to compile-time errors with strong REF CURSORs.
D. You
must close a cursor variable based on a strong REF CURSOR twice because it
persists (strongly) past the first close.
E. A
cursor variable based on a strong REF CURSOR fetches data only into a record
whose structure is compatible with the RETURN clause in the REF CURSOR.
Click Here for the Answer!
|
| |
