|
|
Free
Oracle Utilities
Useful Java Methods for PL/SQL
Author: Steven Feuerstein (feuerstein@revealnet.com)
This zip contains two files:
JFile.class and xfile.pkg. The Java class definition exposes several
useful methods from the File fundamental class. The xfile package
wraps those methods within a PL/SQL layer of code that allows PL/SQL
developers to perform such operations as delete a file, make a directory and
retrieve all the files found in a directory. Click
Here for the utilities.
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
Using
Prefetch to Tune Applications
|
| 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: "Redo Logs on RAID 0 or RAID 5?"
Pipeliners discuss the performance impact of Redo logs on RAID arrays.
Examples and White Papers are included.
- PL/SQL Pipeline
Conference: Oracle 8i and PL/SQL 8i
Subject: "Inserting Values from a Record"
Pipeliner Phyllis Helton and others discuss
strategies for inserting values from a record into a table without having to
specify them by name.
|
| Pipeliner of the Month:
Andrew Simkovsky
Andrew Simkovsky has been a very active
Pipeliner ever since he first logged on to the pipelines in August,
1999. Andrew can usually be found in the thick of a discussion or
debate adding his comments. Andrew is a DBA with AuctionWorks.com in
Atlanta, Georgia.
|
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.
|
| Random
Notes
Win a Free Conference Registration
We're giving away a free Conference
Registration to IDUG 2001 - North America. Make sure to get your
entry in before the deadline! Click Here for details!
Happy New Year!
We would like to express our sincere
appreciation to all that have helped RevealNet grow throughout the past
year. We would like to thank our customers and contributors for your
enthusiastic support and we look forward to supporting the future needs of IT
professionals worldwide.
2001 will bring many new additions to the
RevealNet family of products. Make sure to keep reading the Pipeline
Newsletter to get the latest product news. As always, we welcome
your comments, feedback and suggestions to help better serve your needs.
RevealNet PL/SQL Pipeline Receives Lightspan's StudyWeb Recognition
RevealNet's PL/SQL Pipelines won Lightspan's StudyWeb® recognition in
December. StudyWeb has recognized the PL/SQL Pipeline as being
"one of the best educational resources on the web."
StudyWeb is one of the premier sites for educational resources for
students and teachers. We'd like to thank all of our Pipeliners for
making the PL/SQL Pipelines such a great resource!
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.
|
|
|
 | Knowing
when to Rebuild Oracle Indexes
By
Brian Peasland, USGS - EROS Data Center |
Indexes provide a fast and efficient method
of retrieving selected data from a table. By pointing to the blocks
that contain the selected data, the entire table does not have to read in
order to extract the required information. Most indexes in Oracle
databases are built using the B-tree data structure. Contrary to some
widely accepted beliefs, indexes in Oracle are not self-balancing.
After a table experiences a large number of inserts, updates, and deletes,
the index can become unbalanced and fragmented and can hinder query
performance. Knowing when to rebuild the indexes is a topic of some
confusion. Click Here for the paper.
|
| Tuning
DB2 Data Sharing Performance
Techniques for Reducing
Overhead and Improving Efficiency
By
Robert Catteral, CheckFree Corporation |
Successful Internet-based electronic businesses
continually face the challenge of managing large increases in transaction
workloads while maintaining high levels of application availability.
CheckFree Corp. is no exception to this rule. The company recently
extended the scalability and availability of its DB2 for OS/390 enterprise
data server by implementing a DB2 data sharing group on a System/390
parallel sysplex. Click Here for the article.
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!
|
| Using
Oracle 8i's ROLLUP Feature
By
Vijays, Datacons |
Oracle 8i's ROLLUP feature enables a SELECT
statement to calculate multiple levels of subtotals across a specified group
of dimensions. It also calculates a grand total. ROLLUP is a
simple extension to the GROUP BY clause, so its syntax is extremely easy to
use. The ROLLUP extension is highly efficient, adding minimal overhead
to a query. This paper explores the syntax and use of the ROLLUP
command. This month's PL/SQL Tip explores further examples of Oracle's ROLLUP and
CUBE functions. Click
Here for the Tip.
Note: All articles in the Pipeline
Newsletter have been published with the written permission of their
respective authors.
|
RevealNet Product
Focus
|
 |
RevealNet
announces:
Corporate Knowledge Pack
Your Complete Knowledge
Solution for Oracle Lifecycle Management
|
RevealNet's new Corporate Knowledge Pack gives
DBAs and Developers complete integrated access to our suite of best-selling
Oracle products:
- Knowledge Base for Oracle Administration
- Knowledge Base for Active PL/SQL
Development
- Instant Messages for Oracle
- PL/Formatter
Active DBA's and Developers must wear many
hats. Sometimes DBAs need to roll-up their shirtsleeves and dive into
development projects. Developers are often pulled into projects that
require an administrative perspective. Now, the Corporate Knowledge
Pack allows you to choose exactly the product you need to solve your
problem. Click Here for a complete listing of what you get.
The Corporate Knowledge Pack is a
site-licensed product available to organizations with 5 or more named
users. You will receive the products above, plus all upgrades and
enhancements to these products throughout the next year. Key
advantages to the Corporate Knowledge Pack are product bundling discounts
and reduced long-term maintenance costs.
Special upgrade plans are available for
existing RevealNet customers that wish to upgrade to the Corporate Knowledge
Pack. For more information about licensing and pricing please call us
at 301-947-7744 or email to info@revealnet.com.
|
 | Partner
Focus: TUSC
|
| RevealNet,
developer of knowledge-based solutions, and TUSC, a recognized leader in
Oracle consulting, recently formed a three-year technology and reseller
partnership. RevealNet will supply TUSC's consultants with its
complete line of Oracle Knowledge Bases and development tools. TUSC,
in turn, will demonstrate and make RevealNet products available for resale
through its distribution channels.
TUSC leverages its industry-recognized Oracle
expertise with solid business knowledge to ensure successful implementation
in the core areas of Database Services, Expert Business Solutions, Remote
Database Administration and Training & Mentoring.
RevealNet trial CDs are available at TUSC
training classes in Denver and Chicago. Click for a listing of course
descriptions and course
schedules.
|
 | 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?
A. The
SOUNDEX value always begins with the first letter in the input string.
B.
SOUNDEX uses only the first two consonants in the string to generate the return
value.
C. Only
consonants are used to compute the numeric portion of the SOUNDEX value.
Except fr a possible leading vowel, all vowels are ignored.
D.
SOUNDEX is not case-sensitive. Both uppercase and lowercase letters
return the same SOUNDEX value.
E. The
letter Y is considered a consonant for purposes of SOUNDEX's analysis.
Click Here for the Answer!
|
| |
