RevealNet Pipeline Newsletter

All articles have been reprinted with the written consent of their respective authors.

RevealNet Joins Quest Software.

This script demonstrates how to use UTL_HTTP.REQUEST_PIECES to retrieve a web page into a clob field. The web page is saved twice to the same record. In one field the case is preserved. In the other field, the case is all made lower to simplify searching. The lower case field is used for searching, but the preserved case field is used for display. Included in the package are some procedures using DBMS_LOB functions for searching and displaying the content. Click Here for the Script.

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.

SDOUG is working with the Mission Bay High School on creating projects using databases that will be accessed through Oracle Portal. In addition, we want to create an Oracle Portal site for SDOUG. The prerequisite of all this is setting up a reliable server that is secure and can house the test databases. This paper outlines all the steps the authors took to install Oracle9i on the server.

Do you have a Users Group paper or presentation you would like to share with your colleagues around the world? Send your paper to cwhite@revealnet.com for possible publication in the Pipeline Newsletter. If your article is accepted, we will mail you a canvas, embroidered baseball cap and your article will be distributed to over 23,000 subscribers.

This concise pocket reference, authored by RevealNet and published by O'Reilly & Associates (76 pages) contains a series of easy-to-use checklists providing helpful reminders of the procedures Oracle DBAs must follow when performing common database administration tasks. In this book, you will find checklists for database management, installation and configuration and network management responsibilities.

Information Technology is growing and evolving at an amazing rate. The application development lifecycle has been redefined with the acceptance of the internet. Many of the popular application packages provided by vendors such as SAP, PeopleSoft and Siebel use multiple technology layers. Keeping these applications performing optimally is an intense challenge because of the scope of the technology and technical diversity of the application. This paper discusses all facets of DB2 UDB performance monitoring and presents Quest Central for DB2 - a complete solution for DB2 UDB performance monitoring.

RevealNet is actively looking for 3-4 more SYSOPs to moderate the DB2 Pipeline. We are especially looking for professionals with UDB experience for OS/390, Unix and NT platforms. If you are an experienced DB2 professional, enjoy the challenge of volunteering and answering questions, please contact Michael Gilsbach at RevealNet (mgilsbach@revealnet.com). If you qualify, you will be given complete management access to the DB2 Pipeline, allowing you to easily moderate message traffic. Perks include free personal use of RevealNet's DB2 Knowledge Base and stylin' Pipeline SYSOP apparel. Our goal is to make the DB2 Pipeline the best support forum in the world for DB2 professionals.

This article comes from one of our readers in Hungary. Szabo discusses the implications of using the new feature, and our Pipeline SYSOP team comments on the article. Click Here for the full article.

Another Free Book Offer!

Get the "Oracle PL/SQL Language" Pocket reference FREE! Here's how:

Download and install the 30 Day Free Trial version of RevealNet's Knowledge Base for Active PL/SQL Development AND Formatter Plus from www.revealnet.com
Call RevealNet at 301-947-7744 and ask for a 20 minute walk-through of the products.
After completing your walk-through, we will mail you your free book. Sorry, this offer is valid in the United States and Canada only.

This pocket reference (94 pages) provides quick-reference information that will help you use Oracle's PL/SQL language, including Oracle 8i features. It is a companion to Steven Feuerstein and Bill Pribyl's best selling Oracle PL/SQL Programming book. This book boils down the most vital information from Oracle PL/SQL Programming into an accessible summary of fundamental language elements (e.g. block structure, identifiers, variables, datatypes, and declarations); statements for program control, cursor management, etc. Install the products today and call for your walk-through.

Standards are useful in just about any activity. Although it might take some time to get used to a uniform way of doing work, it will certainly pay high return dividends when you are maintaining your own or someone else's code down the road.

Conventions for writing code become especially crucial when working with a team of developers. Just imagine what would happen if everybody used their own favorite way of coding. It would be rather difficult to review and comment on code written by different team members. If one of these members were to be assigned to a different project it would not be an easy task to maintain his or her work. Code reviews are one of the best ways to learn good programming techniques, not only for people who read the code, but also for the author. Click Here for the topic.

Visit us at the SQL Server PASS Conference, September 19-21
Walt Disney Swan & Dolphin Resort Hotel - Orlando, Florida

Stop by booth 503 at the entrance of the Exhibit Hall and sign up to win a free Bose^TM Wave Radio. This conference will mark the debut of RevealNet's Knowledge Base for SQL Server Development.

Make sure to also visit Quest Software at Booth 407 and check out I/Watch^TM, Spotlight^TMon SQL Server, and Benchmark Factory^Ž - great tools for SQL Server Database Administration. See you there!

We are delighted to announce that RevealNet has officially joined Quest Software. RevealNet and Quest have enjoyed a very close working relationship over the past several years, and this agreement sets the stage for developing and launching a host of new products. RevealNet Labs will continue to develop state-of-the-art technical knowledge bases, development and administration tools for Oracle, DB2, and SQL Server. The Pipeline communities and Pipeline Newsletter will continue to be supported and enhanced. Quest Software is about delivering amazing value to its customers and this acquisition helps to further Quest's commitment to excellence.

Quest Software - RevealNet Labs will be launching the RevealNet for SQL Server Development Knowledge Base at the SQL Server PASS Conference September 19-22 in Orlando, Florida. This product is a comprehensive online reference covering the lifecycle of Transact SQL development. The product is complete with best practices, syntax diagrams, reusable examples and a code library. Click Here to download a 30-Day Beta/Trial version.

Quest Software - RevealNet Labs would like to extend a warm welcome to Brian Peasland, the newest member of the Pipeline SYSOP staff. Brian has been very active on the Pipelines and can often be found in the middle of intense technical discussions. We are honored to have such a great team of volunteer SYSOPs hosting our Pipeline communities.

The Knowledge Base for Oracle Administration captured a 5-Star rating, highest of all products reviewed on the site. ORAFAQ.com is one of the top information sites on the web for Oracle professionals. Click Here for the review.

"What I need is a specific list of unknown problems we can expect to encounter!"
Click Here for a list of real life Dilbert-isms. Do you have a Dilbert-ism you would like to share? Email it to cwhite@revealnet.com. We will publish them in future issues of the Pipeline Newsletter.

Pipeline SYSOPs Mike Ault, Andrew Simkovsky, and Brian Peasland discuss options for table and index sizing. Scripts are included with this discussion. Click Here for this month's discussion.

RevealNet Lab's Pipeline Communities are rich in technical discussions. Each month, we highlight particular discussions of interest. Log on to "Pipe Talk" and share your ideas with your colleagues around the world.

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 Quest Software - RevealNet Labs 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 23,000 readers.

Quest Software - RevealNet Labs
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

This newsletter is distributed to Quest Software - RevealNet Labs 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.

Do you know someone who would like to receive the Pipeline Newsletter? If so, please enter their email address in the box below and click SUBMIT.