|
|
| Feature Code Archive
Passing
NEW and OLD Pseudo Records to Procedures
Author: Steven Feuerstein, RevealNet,
PL/Solutions
A common desire when writing database
triggers is to pass the NEW and OLD pseudo records to procedures for
processing. Even though NEW and OLD have the same structure as a
table-based record (%ROWTYPE), you CANNOT pass them as parameters
directly. Instead, you must copy the contents of those pseudo records
field by field to a locally declared record and then pass that.
Tedious! Boring! So why not generate the code that does the trick for you?
|
Tips of the Month
DB2 Tip of the Month
Host
Variables without Colons
|
| 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
- " Standby Database - NT" in the General Oracle Administration
Conference. Pipeliner Robert Freeman waxes poetic about his problems
associated with creating standby and primary databases on the same NT host.
- PL/SQL Pipeline
- "Tuning SQL" in the Debugging, Tracing, Tuning PL/SQL Code Conference.
Pipeliners work together to resolve problems associated with an expensive (8
hour) SQL statement.
|
| Pipeliner of the Month:
Solomon Yakobson
Solomon first logged onto RevealNet's
Pipelines in November, 1997. Since then, he has posted over 1,200
messages on the pipelines. Solomon can often be seen offering his
insights on especially perplexing or nasty problems. His messages are
thorough, and reflect the depth of his Oracle experience. Solomon and
his family reside in Middlebury, CT. |
| 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
We're moving! Due to expansion, our
Sales Office will be moving in late August. The new office address
will be:
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 last month's Humor Article ("Killer
Kangaroos Assault Australian Air Force"), we mentioned that we
weren't sure whether the story was fact of fiction. John Reddy
writes "Well according to the "Urban Legends Reference
Pages" it's almost true." For the real story, click
here. |
| 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
Real-Life Recovery
Perspective, Preparation and
Performance
By Daniel W.
Fink, 7S Consulting |
In
an anonymous office building downtown, an Oracle database administrator
checks the log files to verify that the backup processes ran properly last
night. Then he grabs a 2nd cup of coffee and moves on to the day's
tasks, emergencies and assorted events. Users, managers and developers
are concerned with data accuracy, proper security and blinding performance,
not in the mundane task of testing recovery. Little does he or the
company know that the past month's backups are useless. Since the
recent operating system update, the tape drive, the only tape drive on site,
writes without error, but cannot read a single bit that is on the tape.
Click Here for the paper |
| Designing
DB2 Start and Stop Dates for Performance and Simplicity
By
Joe
Geller, author, "DB2 Performance and Development Guide",
"IMS Administration, Programming and Database Design" |
Many kinds of data are in effect for a time
period. When modified, a new row is stored with the new
information. For good performance and ease of query, it is important
to design the table with the correct choice of effective date, or a start
and stop date. Index design is also critical to performance. Click Here
for the article.
|
| Creating
Access Key Shortcuts in Forms
By
Peter Koletzke (excerpt from Oracle Developer Advanced forms and
Reports, Osborne/McGraw-Hill, Oracle Press, 2000) |
In forms that require heavy data entry, users
find it easier to use the keyboard for many operations. When you
design forms in this category, you need to consider how the user can use the
keyboard to navigate from one item to another and to activate buttons.
It is easier to move the cursor by pressing keys when your hands are on the
keyboard than by reaching for, moving, and clicking the mouse. Your
forms can be used more efficiently if you take this into consideration
Click Here for the
paper.
|
RevealNet Product
Focus
|
|
| Optimizing
Your Code with PL/Formatter |
Have you ever gotten migraine headaches sifting
through and maintaining someone else's "spaghetti code?"
Does it hurt when you try to analyze the performance of that code"
Do you wince when you discover that a tiny typo was the only thing standing
in the way of your code compiling? PL/Formatter is the fastest, most
inexpensive way to optimize your code, catch mistakes, and format your code
instantly. Click Here
for a closer look.PL/Formatter is
widely regarded as the Industry Standard for Oracle source code
formatting. It is integrated with leading 3rd party software vendors
including Allround Automations, Computer Associates, Embarcadero
Technologies, Quest Software and Sylvain Faust, Intl.
|
| How
to Trial RevealNet Knowledge Bases |
RevealNet Knowledge Bases are designed to
fully anticipate the daily challenges faced by working Oracle and DB2
professionals. When you download the new, 30-day trial versions of the
software, remember that you will have first-rate assistance on thousands of
technical issues at your fingertips. Please
avoid the most common mistake of "setting time aside" to look at
the Knowledge Bases. These products are designed to work when you are
at your busiest. A quick key-word search and a mouse click can save
you hours of time and keep you from shutting down to hunt for information in
the manuals.
When you download the software, give us a
call at 800-738-3254. Any of our representatives will be happy to take
you through a quick, 10-minute guided tour of the software. They will
point out the ease of navigation, fast cross-referencing techniques, and how
to add your own docs and notes to any topic or error message.
|
Partner
Focus: Embarcadero Technologies
|
|
 | Getting Fast Technical Expertise Inside DBArtisanTM,
Rapid SQLTM
RevealNet Knowledge Bases Now Available Directly from your
Embarcadero Sales Representative |
RevealNet's Knowledge Bases for Oracle and
DB2 are now available directly from your Embarcadero Sales Representative as
optional modules that integrate inside Embarcadero's popular DBArtisanTM
and Rapid SQLTM
products. Simply highlight a keyword or error message and click the
right mouse button. RevealNet's knowledge bases will drill-down
directly to your issue
In just seconds, you will have the background
information, syntax diagrams and working examples you need to help solve
your problem. Instant Messages gives you a consolidated index of
25,000 Oracle error messages across multiple versions of Oracle. The
beauty of this integration is that you never exit DBArtisanTM
or Rapid SQLTM
to look for technical information. It is delivered to you exactly when
you need it. You can stay much more focused when you have the tools to
solve problems when they occur. Click
Here to see how RevealNet integrates with DBArtisanTM
and Rapid SQLTM
|
| 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