|
|
Free
Oracle Utilities
Digging Deep Into STANDARD.SQL
Author: Solomon Yakobson
RevealNet's Pipeline Communities are
excellent forums for the sharing of technical information. One or our
Pipeliners, Solomon Yakobson "hacked" the STANDARD.SQL package and
discovered a wealth of functionality soon to be released by Oracle.
Today I had some free time on my hands and
decided to browse through the STANDARD.SQL package on Oracle 8.1.6.
I'm so glad I did. I bet most of us had issues with DATE datatype.
Not being able to store just time, not being able to do time intervals, not
being able to get date and time with less than a second precision, not being
able to handle time zones, etc, etc, etc. Let me tell you, looks like
these dates are over. All of the above features are already in PL/SQL
- they are just disabled. And if you dare, you can enable them
(courtesy of Oracle developers leaving comments in STANDARD.SQL).
Anyway, I've done it before, and I did it again. Here it
is.
Win a Free Cap! Donate useful
code to the Pipeline Library, and we will mail you a "stylin"
RevealNet baseball cap if your utility is published in the newsletter.
|
Tips of the Month
DB2 Tip of the Month
UDB
5.2 to 6.1 Migration Tip for NT
|
| 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: Configuration Management
Subject: "What Should Be SGA Size?"
Pipeliners discuss the merits of several strategies for SGA sizing.
- PL/SQL Pipeline
Conference: General PL/SQL Discussions
Subject: "Hacking Pays Off"
Solomon Yakobson's discovery of hidden functionality inside the STANDARD.SQL
package touched off a flurry of comments from PL/SQL gurus, including Steven
Feuerstein and Chris Racicot, head of Oracle's PL/SQL development team.
Get the inside scoop on some new PL/SQL features scheduled for Oracle 9i.
|
| Pipeliner of the Month:
Shankar Govindan
Shankar is a newcomer to the Pipelines, and
we are delighted that he has already submitted two papers for publication in
this newsletter. Shankar is an Oracle Applications DBA with Syntel,
Inc. and his also an Oracle Certified Professional. He lives in
Portland, Oregon with his wife and 5 year old daughter. Hobbies
include frog-hunting (personal consumption) and trekking. Motto:
"If you cannot do it, someone else will."
|
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
RevealNet's Pipeline Communities Reach
20,000 Members
The RevealNet Pipeline communities continue
to grow at an impressive pace. With steady daily growth, we have now
registered over 20,000 members. Average daily attendance on the
Pipelines is 500 visitors, and over 100 questions/answers are posted each
day - making the Pipelines one of the most active forums for database
professionals.
RevealNet Website Receives "Critical Mass Award"
RevealNet's website won "Critical Mass Award" recognition in
November. Quotes Bill Darling, of Critical Mass "A very nice
site, excellent design, beautiful original graphics, clever artwork, and
your content is informative, entertaining, presented well and easy to
access. A worthy enterprise and a positive contribution to the
Web." Critical Mass evaluates websites for content and
contribution to the web.
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.
|
|
|
 | Oracle
Database Cloning Using Hot Backups
By
Shankar Govindan |
Most
sites running Oracle databases need the latest production databases to be
cloned for the development and test teams to work on. This is
especially true when you are working on an Oracle Applications site where
patches have to be applied and tested first before applying the same on the
Development box. This document gives
you a detailed flow of how to backup the database in a 24x7 operation and
use it for cloning a Development or Test database. By using the
System switching of Log files option, it reduces the amount of archive logs
to be applied and therefore reduces the time of recovery (the goal).
Click Here for the paper. |
DB2 has enabled users to store multimedia data
since Version 1 with VARCHAR and VARGRAPHIC data types. But VARCHAR
and VARGRAPHIC data types provide limited functionality when compared to
LOBs. The maximum size of VARCHAR or VARGRAPHIC columns is 32KB.
This limitation may not pose a problem for smaller databases, but the
requirements of most modern applications usually dictate the need for larger
multimedia data types. A 32 KB text document is not a very large
document at all. And, 32 KB is miniscule when it comes to storing
multimedia data types such as audio, video, graphics, and images. Click
Here for the topic.
|
|
It seems that Oracle Designer is a tool that
everyone either loves or hates. Those who love it appreciate its rich
repository that offers centralized system development work. Those who
hate Designer are confused or frustrated by its complexity and steep
learning curve. This paper presents a dozen
categories of the author's top tips to assist you, both in learning Oracle
Designer and in applying it to a system development process.
|
RevealNet Product
Focus
|
|
 | Fall
Knowledge Base Releases Now Available for Oracle and DB2
Focus on Web Development, Web
Administration, Data Warehousing |
Monday, November 13, 2000 - The Fall/Winter
v2000.2 releases of our Knowledge Bases for Oracle and DB2 are now
available. Hundreds of new topics and several new product features
have been added. To download 30-day trial versions, Click
Here.
New sections on Web Development, Web
Administration, Data Warehousing, Application Security and Oracle8i
Built-ins have been added to the Knowledge Bases for Oracle Administration and Active PL/SQL
. For a complete listing of new product enhancements,
Click Here.
Existing RevealNet customers under
maintenance have been notified via email with instructions for downloading
this latest update. If you purchased your Knowledge Bases from
Embarcadero Technologies, Quest Software or Sylvain Faust, please contact
their Support representatives for your updates.
|
Partner
Focus: Quest Software
|
|
 Adding
Knowledge Solutions to SQL NavigatorTM
and TOADTM |
RevealNet's Knowledge Bases and Development
tools are powerful add-on modules that tightly integrate with Quest
Software's flagship development products: SQL NavigatorTM
and TOADTM.
RevealNet products can be ordered directly from your Quest Software
representative. Click Here
for the Quest Software Data Sheet.
RevealNet's Knowledge bases for Oracle
Administration and Active PL/SQL
Development save hundreds of hours of administration and development
time. Here's a brief recap of what you get:
- Over 5,000 topics on Oracle Technology
(v7.3-8.i)
- Instant Messages for Oracle - 25,000 error
messages
- 200 Database Administration Scripts
- PL/Vision: a Code Library with 1,000
procedures and functions
- Customizable - Add your own notes and docs
to any topic
- Knowledge Bases Updated twice each year
PL/Formatter
automatically formats Oracle PL/SQL source code to your own, predefined
standards. Widely regarded as the industry standard for source code
formatting, PL/Formatter also catches syntax errors offline and provides
expert recommendations for optimizing your code. For more information
and screenshots of RevealNet products working inside SQL NavigatorTM
and TOADTM,
Click Here.
|
| 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. Which
of the following statements accurately describe an object view and its
capabilities?
A. An
object view is any SQL view found in the ALL_OBJECTS data dictionary view.
B. An
object view is a view that presents data stored in relational tables as an
object.
C. You
can use an object view to navigate using REFs rather than joins.
D.
Object views can help you circumvent "schema evolution" problems that
arise when working with the object layer of the Oracle RDBMS.
E. If
you decide to use object view, you can no longer make direct references to
relational tables in your application.
Click Here for the Answer!
|
| |
