|
|
Free
Oracle Utilities
CSV File Utility
Author: Anthony Whitehead (bricky@dircon.co.uk)
This process was designed to take a .CSV file
as input and return the values in a nested table for programmatic
control. It caters with encompassed quotes, in the same way that SQL
Loader has an 'Optionally enclosed by' option. It's useful if you are
reading in data that has an indeterminate number of columns and repeating
groups. Click
Here for more information about this utility. Format: SQL
file, 2KB
Win a Free Cap! Donate useful
code to the Pipeline Library, and we will mail you a "stylin"
canvas/embroidered RevealNet baseball cap if your utility is published in the newsletter.
Just submit your code archive to cwhite@revealnet.com
|
In Bookstores
this Month:
"Oracle DBA Checklists"
Pocket Reference,
Author: RevealNet
O'Reilly & Associates, 96 pages
This pocket reference addresses the daily,
weekly, and monthly responsibilities of a working Oracle DBA. Useful
checklists are included for database management, installation &
configuration, and network management issues. The book will be
shipping April 15. "Oracle DBA Checklists" is
available from the Illuminations
Bookstore, Amazon, and wherever O'Reilly
books are sold.
|
Tips of the Month
DB2 Tip of the Month
Influencing
the Optimizer with OPTHINT
|
| Discussions of the Month
RevealNet's "Pipe Talk" forums are
among the richest technical discussion groups on the net. Log on to Pipe
Talk and share your experiences with your colleagues around the world.
This month's feature discussions are:
- Oracle DBA Pipeline
Conference: The Beginning DBA
Subject: "Oracle Apps Worth A lot?"
Shankar Govindan provides an excellent insight into the life of an Oracle
Applications DBA. Click Here for an excerpt of the discussion.
- PL/SQL Pipeline
Conference: Beginner PL/SQL
Development Questions
Subject: "MEDIANS??"
Pipeliners debate methods for writing functions that will correctly return
median values.
|
| Pipeliner of the Month:
Sunil Maruvada
Sunil Maruvada is one of the top 10 message
posters on the PL/SQL Pipeline. He first logged on in August, 1999 and
has since posted over 650 messages. Sunil is originally from Bilaspur,
Madhya Pradesh, India. He received his Master's Degree in Computer
Engineering from Memphis State University, and works as a senior technical
staff member for Verizon in Raleigh, North Carolina. Sunil is a
newlywed, having married his wife, Rashmi, on February 11,2001.
Congratulations Sunil! |
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'"
canvas/embroidered 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
A Pipeliner is Born?
|
|
Congratulations to Jonas Nordstrom, a
regular Pipeliner from Malmo, Sweden. Jonas is a new father, and
posted a picture of his first child, Jack. Congratulations, Jonas!
|
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.
|
 | Past
Issues of the Pipeline Newsletter |
|
|
|
 | Oracle
8i Partitioning Methods
By
Vijayabaskar Srinivasan, Datacons |
Partitioning addresses the key problem of
supporting very large tables and indexes by allowing you to decompose them
into smaller and more manageable pieces called partitions. Once
partitions are defined, SQL statements can access and manipulate the
partitions rather than entire tables or indexes. Partitions are
especially useful in data warehouse applications, which commonly store and
analyze large amounts of historical data. Click Here for the article.
|
| DB2
Existence Checking, Good vs. Bad
By Isaac Yassin |
Sometimes you need to check if specific data is
in a table in order to decide what to do. This PowerPoint presentation
compares several approaches, both good and bad, for existence
checking. Click Here to
download the presentation.
|
IDUG
Contest Winner!
Diane Schultheiss, Norfolk
Southern - Atlanta Georgia
Diane is the winner of a FREE full-conference registration to IDUG 2001 in
Orlando, Florida May 13-17. Hotel, travel and expenses not
included. Congratulations, Diane! |
|
| Making
Code Review a Regular Part of Your Development Process
By
Steven Feuerstein, Quest Software
Extracted from Steven's new book "Oracle PL/SQL Best
Practices", O'Reilly & Associates. This book will be
available April 15th, 2001. This topic is reprinted by
permission from Quest Software's re:Quest newsletter. |
Developing a formalized Code Review process
dramatically improves the quality, maintainability, and reliability of your
code. This topic identifies the need for Code Review, and discusses
several methods for reviewing source code. Click Here for the topic.
Do instant Code Reviews with Formatter PlusTM.
Download the Demo now!
Note: All articles in the Pipeline
Newsletter have been published with the written permission of their
respective authors.
|
RevealNet Product
Focus
|
 |
Formatter PlusTM Now
Available
The Professional's Tool for
Analyzing & Formatting PL/SQL
|
April 2, 2001 - Rockville, MD RevealNet
today announced the General
Availability of Formatter
PlusTM
. Formatter PlusTM
is a powerful, flexible product capable of Formatting, Code Reviewing and
Profiling entire PL/SQL applications instantly. More robust than it's
sister product (PL/FormatterTM),
Formatter PlusTM
delivers in 5 major categories:
- Format
- An entire application, or a single file, with a single mouse-click.
- Code
Review - Instantly review your code for correctness,
maintainability, efficiency, readability and program structure.
- Syntax
Check - Catch syntax errors across all of your files instantly -
without being connected to Oracle.
- Navigate
- Organize and easily navigate through complete projects or individual
files using a Drag-And-Drop browser interface.
- Knowledge
- Extensive Code Review Tips and tight integration with RevealNet's
Knowledge Base for Active PL/SQL Development (sold separately) gives
you insights, best practices and code examples immediately.
Formatter PlusTM
will also be replacing PL/FormatterTM
in RevealNet's Developer's Toolkit.
Download Your Demo Now!
Click to Enlarge
| Product Reviews
"Formatter PlusTM
can validate PL/SQL code quickly, and flags problem spots in the code.
It also provides easy access to examples and coding rules." -
Robin Fingerson, TUSC for SELECT Magazine
"I loaded
75 packages (1.8MB) into Formatter PlusTM. Formatting all these
documents took about 10 seconds, and I'm not even on a Pentium
III. The speed of Formatter PlusTM is excellent." - Gerrit-Jan
Linker, Product Reviewer, ORAFAQ
"I was able to
correctly syntax-check some very large and complex PL/SQL
programs. I deliberately broke a deeply nested, complex piece of
PL/SQL code, and Formatter PlusTM correctly identified the
error." - Dan Clamage, Clamage Computer Consulting
"The Formatter
PlusTM Code Review and Code Profiler features are ahead of their
time. This tool is a "must have" for every developer
and DBA." - George Mbogo, DBA, RevealNet Customer
|
Frequently Asked Questions
What makes Formatter PlusTM different from
PL/FormatterTM?
Plenty. Click Here for a document showing a side-by-side
comparison of both products.
Is Formatter PlusTM easy to use?
Very easy. Download the DEMO and print the "5 minute
walk-through". Within minutes you will be formatting, code
reviewing, and analyzing files faster than ever.
How much does Formatter PlusTM cost?
Just $199 (US).
I already own PL/FormatterTM. How can
I upgrade to Formatter PlusTM?
If you are a PL/FormatterTM customer under maintenance with RevealNet, you
may upgrade to Formatter PlusTM for just $75.
Will Formatter PlusTM work with my current
IDE?
Formatter PlusTM is compatible with several popular Integrated
Development Environments, including SQL NavigatorTM,
TOADTM, Rapid
SQLTM,
SQL ProgrammerTM, and PL/SQL Developer.
What will the DEMO let me do?
The DEMO of Formatter PlusTM is loaded with a sample project consisting
of several files. You can format, code review, and analyze any of the
files in the sample project. You will not be able to import your own
files, format or save them.
|
|
|
Spring
2001 Release of the Knowledge Base for Active PL/SQL Now Available
|
| April 2,
2001 - Rockville, MD The Spring v2001.1 version of RevealNet's
Knowledge Base for Active PL/SQL Development is now available from
RevealNet's website. The major emphasis of this new update is
"PL/SQL Best Practices". Several new topics have been added
on program structure, code review and writing bullet-proof code. The
knowledge base is also tightly integrated with the core functionality of
Formatter PlusTM.
Download the 30-day trial version today!
|
|
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
|
|
|
