|
|
| Feature Code Archive
Create
or Replace Procedure table_sizing
Author: Bob Rudolf, Precision
Computer Systems
This code will compute the table size for
unpopulated tables using the procedures outlined in Jason Couchman's DBA
Certification Exam Guide. This procedure will fill in the table_size
based on the number and types of rows. Modify the cur_in query to suit
your needs.
|
Tips of the Month
DB2 Tip of the Month
Be
Aware of Overactive Data Areas
|
| Discussions of the Month
RevealNet's "Pipe Talk" forums are rich in technical discussions.
Each month, we review the conferences for particularly interesting discussion
topics. Log on to "Pipe Talk" to view discussions and share
technical ideas with your colleagues around the world.
- Oracle DBA Pipeline
- " DBA Checklist" in the FAQ Area. Pipeliners
discuss daily, weekly and monthly DBA responsibilities. This discussion
is an oldie but goodie.
- PL/SQL Pipeline
- "Create a Random Alphanumeric Value" in the Advanced PL/SQL
Programming with Packages Conference. Pipeliners discuss how to create
alphanumeric values that omit the numbers 1, 0 and the letters I, O. The
discussion includes a sample code submission by James Padfield.
|
| Pipeliner of the Month:
Bob Rudolf
Bob ("Keep Smiling") Rudolf is the
author of this month's Code Archive and a very frequent contributor to the
Pipelines. Bob first logged on in September 1998 and has since posted
over 350 messages. Always willing to lend a hand, Bob can be
frequently seen offering his assistance when people are stuck with
problems. Thanks Bob, and "Keep Smiling"! |
| Call for
Articles
Part of our mission at RevealNet is to
encourage the sharing of technical information among database professionals
worldwide. If you have a technical article, tip or coding solution you
wish to share, please email your submission to cwhite@revealnet.com.
As a humble gesture of our thanks, we will acknowledge the author or each
accepted article, and mail him/her a "stylin'" RevealNet baseball
cap. |
| Random
Notes
RevealNet is ranked in the top 4 percent of
most actively linked websites, with a #21519 ranking out of 589204
websites, according to the WebsMostLinked.com database!
We would like to extend a special thanks to
the event coordinators at ODTUG 2000 and all of the attendees who visited
with us in Fort Lauderdale June 12-14. The conference was
first-class in every category - from technical content to the food and
entertainment. If you are a developer, ODTUG is definitely your
conference. See you in San Diego next year! Get more info at www.odtug.com.
RevealNet products were demonstrated at
EOUG 2000 in Madrid, Spain June 20-23. Author Mike Ault, president
of DBMentors International and RevealNet Senior Technology Officer,
demonstrated RevealNet at his booth. Muchos Gracias Mike! |
| 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.
|
 | Past
Issues of the Pipeline Newsletter |
|
|
|
This
paper is an excellent resource - giving DBAs the details for performing
daily, weekly and monthly checks on the status of one or more Oracle
databases. All SQL and PL/SQL code for the listed checks can be found
in the appendix. Click Here for the paper |
As of DB2 Version 6, it is possible to create
your own functions to supplement the built-in functions supplied with
DB2. User-defined functions enable you to customize DB2 to your shop's
requirements. This is a very powerful feature of DB2 UDB.
However, it is also complex and requires detailed knowledge, additional
application development skills, and extra administrative handling. Click Here for the article.
|
|
Since Oracle 7.1, PL/SQL developers have been
able to use the built-in DBMS_SQL package to execute dynamic SQL and
PL/SQL. But there are some problems with DBMS_SQL:
- It is a very complicated package.
- It has a number of restrictions (such as
not recognizing and being able to work with new Oracle8 datatypes).
- It is relatively slow.
So dynamic SQL, was re-implemented directly
in the PL/SQL language itself. This new facility is called Native
Dynamic SQL. Native Dynamic SQL is faster and easier to use than
DBMS_SQL. Click Here for the topic.
|
 | Humor:
The Perils of Code Recycling
Killer
Kangaroos Assault Australian Air Force |
This story was
posted recently in the Jokes section of the PL/SQL Pipeline. It was
posted by Bill Pribyl from Datacraft, forwarded to him by Debby Russell at
O'Reilly. We're not certain where it came from, or if it's even true,
but it ought to be! Click Here for the story.
|
RevealNet Product News
|
|
| How
to Certify a Database for Production
|
Too often, databases are put in production
without really checking to make sure they are ready. The new v2000.1
release of the RevealNet Oracle Administration Knowledge Base includes
checklists for certifying your core database and application database for
production. These Checklists cover 34 steps from Prep-Work to database
creation, configuration, security and post-implementation issues. If
you need any help during a step, just click the "More Info"
button.
To find out what's new in RevealNet's
Knowledge Bases, click on "Help", then "Version
Highlights". Click Here to download a 30-Day Trial of the Oracle
Administration Knowledge Base.
|
| Product
Walk-Throughs Now Available |
One of the problems
with downloading software is the uncertainty of how easy/difficult it will
be to actually use the software. If you're interested in RevealNet
Knowledge Bases, here's our promise: Within 10 minutes, we will make
you a RevealNet Software Expert.
Just install the trial version of your
favorite product and call us at 800-738-3254 or 301-721-0778. Our
staff will take you through a quick guided tour, pointing out the features
that make our Knowledge Bases the best reference tools for Oracle and DB2.
|
Partner
Focus: Quest Software
|
|
 | Solving
Problems Inside TOADTM
and SQL NavigatorTM |
RevealNet's Knowledge Bases can be used as
powerful Knowledge Management tools inside the fully licensed versions of
TOADTM
and SQL NavigatorTM
from Quest Software.
Every day, developers and DBAs encounter
technical problems and error messages that require at least some level of
research to resolve. You browse through dog-eared reference books,
scan the manuals, consult with peers, surf websites or call Oracle for
support. Sometimes the answer comes quickly; other times it can take
hours, even days to resolve your issue. Some problems are so
"site-specific" that a documented answer may not be
available. Almost every problem shares a common trait - you must shut
down what you're doing to hunt for your answer. Click Here for more.
|
| Recent Headlines |
Did you know RevealNet Knowledge Bases and Development Tools are tightly integrated with products and services from these companies? Click on each logo below for more information.
Software
Developers
Reseller Partners
|
|
|
|
Current Product Releases