|
|
 | This pocket reference provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle8i features. |
|
| Feature Code Archive
"Preserving
Indentation in HTML"
Author: Mark Fredericks, PROSOFT
In HTML pages, multiple spaces are displayed
as a single space. Using spaces to indent hierarchies is often required. SQL
CONNECT BY queries use space indentation to show levels of recursive
relations between records. To preserve the correct indentation in HTML,
spaces can be replaced with the non-breaking space tag . The functions below
can be used in producing query results that will display correctly when
viewed by a browser.
Format: PLS file, 3KB
|
Tips of the Month
DB2 Tip of the Month
911
Error Handling
|
| Discussions of the Month
RevealNet's "Pipe Talk" forums are rich in technical discussions. Log on to our free "Pipelines" and share technical ideas with your colleagues around the world!
- Oracle DBA Pipeline
- " Remove a Datafile" in The Beginning DBA. Pipeliners
discuss workarounds for dropping a datafile.
- PL/SQL Pipeline
- "DEFINE_COLUMN vs. DEFINE_COLUMN_ROWID" in the Dynamic SQL with
DBMS_SQL Conference. Pipeliners engage in a philosophical discussion about
costs & "suffering".
|
| Pipeliner of the Month:
John Beresniewicz
John B. is the senior technical product
manager at Savant Corporation, and has been an active pipeliner since this
forum started in 1997. Of the 16,000 registered pipeline members, John is
number 47! John is a regular contributor to the pipelines with over 800
messages posted. He is also a popular speaker at national and regional
Oracle conferences, and co-author of "Oracle Built-In Packages"
from O'Reilly. John and his wife. Arlene live in Gaithersburg, MD. |
| Call for Authors
Do you have a flair for writing? Crave
worldwide recognition? Please submit your
article, paper, tip about Oracle or DB2 technology to cwhite@revealnet.com
Part of our mission at RevealNet is to
encourage the sharing of technical information. As a humble gesture of our
thanks, we will acknowledge the author of each accepted article, and mail
him/her a stylish RevealNet baseball cap. |
| Random
Notes
Happy Birthday! The Pipelines are 3 years
old this month. The original idea was to create a "noise-free"
environment for Oracle professionals to discuss technical ideas, share
code and contribute papers and tips (similar to the old Compuserve ORAUSER
forum). Since it's birth, the Pipelines have grown to 16,000 users, and
welcomes about a dozen new members each day. Over 100 messages are posted
daily on the DBA and PL/SQL Pipelines, making them among the most active
Oracle discussion sites on the web, aside from Usenet.
Congratulations, Comrade Hurley! Darryl Hurley's March/April
Pipeline articles, entitled "Oracle's Log Miner" have been re-published in the Russian Edition of Oracle Magazine! Here's the
link: http://oramag.ru/default.htm?rub=6&ID=89
We are saddened to learn about the death of
Audrey Wages, who recently lost her fight with cancer. Audrey managed the Illuminations
Bookstore and was one of the sweetest, most professional people you
could meet. An avid cat-lover, Audrey requested any donations be made to a
feline rescue league. For more information, 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.
|
|
|
Physical disk I/O is by far the slowest of the three
core components found in all computing devices (CPU, memory, and disk). For that
reason, minimizing the volume of disk I/O and spreading disk I/O out over
multiple physical devices are key elements in the system performance tuning
process. Savant’s Diagnostic Center for Oracle includes a Data
File I/O List. This list display is effective at isolating datafiles and
tablespaces experiencing the most I/O and determining if there are opportunities
to spread the load out more evenly. Click
here for the paper. |
The establishment and enforcing of naming
conventions is often one of the first duties to be tackled when implementing
new software. Adequate thought and preparation is required in order for such
a task to be successful. What amount of effort should be extended in the
creation of appropriate database naming standards? Are current industry
standards acceptable? Shakespeare, many, many years ago, may have said it
best when he wrote:
"What's in a name? That
which we call a rose
by any other name would smell as sweet."
But, if that is true, then why do those of us
in the DP industry spend so much time and effort developing and enforcing
naming standards? Maybe what something is called is not quite so trivial a
matter after all! Click
here for the paper.
|
|
As Oracle technology evolves, numerous
questions have been raised about the future direction of PL/SQL. The Oracle
PL/SQL Team has several new projects planned for release 8.2 and above. A
partial listing of these planned enhancements are listed in the attached
document. As these enhancements become available, stay tuned to the Oracle
Technology Network for announcements.
Click
here for a listing of current
projects.
|
RevealNet Product News
|
|
The RevealNet Oracle
Administration Knowledge Base includes a number of SQL, PL/SQL and Unix
shell scripts. Chief among the SQL and PL/SQL scripts is the core package,
DBMS_REVEALNET. The DBMS_REVEALNET package has evolved over the last few
years from a loosely connected group of functions and procedures to an
integrated package of functions and procedures that can greatly assist the
DBA in the day-to-day database operations. Click
here for more information.
|
 | RevealNet
Spring Products Released May 15 |
| With the v2000.1
Spring/Summer product releases, RevealNet expands its coverage of the new
technology enhancements introduced with Oracle8i and DB2 V6. Syntax
diagrams, error messages, examples, insights and tips have been updated to
help you take full advantage of these enhancements. Visit us at ODTUG June
12-14 in Fort Lauderdale for live demonstrations.. Click
here
for a list of updates.
|
RevealNet Partner News
|
|
 | Buying
RevealNet on the GSA Schedule
DLT
Solutions Offers No-Hassle Federal & State Procurement |
If you are a U.S. Federal, State, Municipal
or Educational Institution, it can be quite difficult to purchase 3rd
party Oracle and DB2 software products without wading through mountains of
red-tape. To ease procurement , RevealNet has partnered with DLT Solutions,
Oracle's largest value-added GSA reseller. GSA pricing insures the lowest,
pre-negotiated government prices for federal, state, municipal and
educational institutions.
"RevealNet products are a natural fit
for our Oracle GSA Schedule Partnership Program," said Ned Miller, Vice
President for Business Development at DLT Solutions. "The addition of
world-class knowledge bases to our product line helps us deliver a total
solution to the Federal and State Oracle marketplace."
For more information about RevealNet products
on the GSA Schedule, click here.
|
| 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.
|
| Past Issues of the Pipeline Newsletter |
|
|
Current Product Releases