|
|
| Feature Code Archive
Utility
for Table Comparison
Author: Steven Feuerstein, RevealNet,
PL/Solutions
Here's a handy Oracle8i utility that allows you
to determine whether or not two different tables are exactly the same -- in
structure and in content (data). It's good for 8i only because it relies
on native dynamic SQL. You could easily convert it to use DBMS_SQL to
run in Oracle7 and Oracle8. Perhaps a Pipeliner will do just that!
Click
Here for the utility.
|
Tips of the Month
DB2 Tip of the Month
Avoiding
maintenance problems with Net.Data on OS/390
|
| 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
- "Query Running Too Slow" in the Performance and Tuning Conference.
Author Mike Ault helps Pipeliner Tony
Omo tune Oracle and Siebel query performance
- PL/SQL Pipeline
- "Sequence in PL/SQL" in the Beginner PL/SQL Development
Questions Conference. Here's a good one for the Olympics - How to best
write a script to extract medal tallies from an athletics competition (Gold,
Silver, Bronze).
|
| Pipeliner of the Month:
Steve Cosner
Steve
Cosner has been an active Pipeliner since April, 1998. In that
period he has posted over 500 messages, with answers and comments to
questions. Steve is a Systems Analyst/Developer at Cal State
University - Fresno and author of "Quick
Access" - a free utility for people using Oracle Forms 4.5-6. |
Humor:
"Ode to a TAR'd Standby Database"
By
Robert Freeman
In last month's Pipeline Newsletter, Robert
Freeman waxed poetic about his experience working with Oracle on a support
issue. Click Here for the poem. |
| Call for
Articles
We would like to express our sincere thanks
to everyone who has recently submitted articles for publication in the
Pipeline Newsletter. It's great to see our readers actively
participating in this newsletter.
Part or 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
Visit us at Oracle Open World!
If you plan to attend Oracle Open World October 1-5, please stop by and
visit with us. We will ship you a free gift and trial CD for
stopping by and seeing the latest in RevealNet technology.
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
In August's Pipeline Newsletter we
published an article by Peter Koletzke from his recent book. In
converting his code for HTML display, his sample code lost it's
formatting. We have since corrected the error and apologize for the
mistake. |
| 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.
|
|
|
 | Oracle
HTML Database Information Reports
Verified with IE 5, Oracle7,
Oracle8
By Jody Wisecup,
Butler Manufacturing |
The
ability to quickly and easily lookup information about databases can save a
DBA a lot of time throughout the day. Information on items such as database
versions, data files, tablespaces, SGA size, rollback segments, options,
database links, and parameter values are things that a DBA use quite
frequently in their day-to-day operations. This type of information
can also be invaluabe to the DBA in disaster recovery scenarios. In
order to eliminate the need for the DBA to run SQL scripts each time this
type of information is required, a web based reporting solution was
developed. The following paper outlines this process and provides the
code necessary to set up an automated Database Information Reporting
procedure in a web based format. Click Here for the paper. |
Net.Data for OS/390 provides the ability to
build business-critical Web applications using your DB2 data as well as
other enterprise data. You can also build interactive Web sites with
data included dynamically from a variety of dat sources, such as relational
data, file data, and Lotus Notes data. A Net.Data-driven application
can get your data to (and from) a worldwide audience. Click Here
for the topic.
|
| All
about CRON Jobs
By Logan
Ramasamy |
When I started as a DBA and tried to run
batch files as cron jobs it was unclear to me how to run cron jobs. I
tried to learn from Unix Administrators. They didn't have time or they
did not want to spare their knowledge. So I learned all about cron
jobs and the following is the outcome. Click Here for the
article.
|
RevealNet Product
Focus
|
|
Have you ever written PL/SQL code and wondered,
"hasn't someone written this stuff before?" Most major
programming languages (C++, Java, Delphi, etc.) have extensive code
libraries available for developers. Why isn't this the case with
PL/SQL? If you do a lot of PL/SQL coding, the Active PL/SQL Knowledge
Base is a great resource to have at your fingertips.The
Active PL/SQL Knowledge Base now includes PL/Vision, a robust Code Library
of 1,000 PL/SQL procedures and functions. Key benefits are:
- You Write Far Less Code
- Improve the Quality of Your Code
- Reduced Maintenance Problems
- Source Code is Unwrapped
- "PL/Vision Pipeline" - Online
Support Forum
The Active PL/SQL Knowledge Base is available
directly from RevealNet, and is also integrated with Integrated Development
Environments from Computer Associates, Embarcadero Technologies, Quest
Software, and Sylvain Faust, Intl.
|
 | GSA
Spot Discount Expires September 30 |
If you are a U.S. Federal, State, Municipal
Agency or Educational Institution, you qualify for a spot discount on
RevealNet Knowledge Bases from DLT Solutions, Oracle's largest value-added
GSA reseller partner. To take advantage
of special savings, contact Cindy Clarkson at 703-708-9623 or cindy.clarkson@dlt.com.
To fill out an online Quotation Request Form, Click
Here. This special
sale will expire on September 30,2000 for U.S. Government and Educational
Buyers.
|
Partner
Update: Embarcadero Technologies
|
|
 | Knowledge
Bases Now Available from Embarcadero.com
|
If you are an Embarcadero customer or
prospect, you can now download and purchase RevealNet Knowledge Bases
directly from Embarcadero Technologies. Click the following links for
more information about RevealNet's integration with Embarcadero's DBArtisanTM
and Rapid SQLTM
products.
|
| 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 |
|
|
Current Product Releases