|
|
 | 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
"Convert Between Numeric Formats" Package
Author: James PadfieldPL/SQL user James Padfield offers a handy set of functions to perform a variety of conversions, all bundled into a package. These conversions include:
- BINARY TO INTEGER CONVERSION
- INTEGER TO BINARY CONVERSION
- HEXADECIMAL TO INTEGER CONVERSION
- INTEGER TO HEXADEXIMAL CONVERSION
- INTEGER TO ANY BASE CONVERSION
- ANY BASE TO INTEGER CONVERSION
|
Tips of the Month
DB2 Tip of the Month
Author: Vincent Woo, IBM Corporation
DB2 Migration Tips & Hints
|
| Discussions of the Month
RevealNet's Pipeline Communites are rich in technical discussions. Log on to the "Pipe Talk" Conferences and share your problems and solutions with your colleagues around the world!
- Oracle DBA Pipeline - "Who Needs Database Constraints Anyway?" in the General Oracle Administration section
- PL/SQL Pipeline - "Functions with Boolean Return Statement" in the Beginning PL/SQL Developer section.
|
| Pipeliner of the Month: James Padfield
James Padfield ("Padders") is an active Pipeliner who joins us from the UK. James first logged on to the Pipelines in August, 1999. Since then, he has posted over 100 comments and solutions on the Pipelines. Padders is the author of this month's featured Code Archive. In grateful recognition, we offer our sincere thanks, and have mailed a stylish RevealNet baseball (cricket?) cap to him. |
| 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's Log Miner, Part II
By Darryl Hurley, MDSI, ImpleStrat Solutions |
Oracle8i introduced Log Miner, a PL/SQL API that allows for all transactions performed in a database to be easily viewed, recreated, audited or undone. In Part I, we covered the overall concept of how Log Miner works as well as how to begin a mining session. We made it as far as actually viewing the contents of redo logs. Now in part II we will delve deeper into those contents to see what they contain and how they can be used. Click Here for Part II. |
Everyone has heard and most have probably experienced some form of e-business. Articles about the Internet abound. Bus shelters, business cards and billboards now carry website addresses. This article will examine what role DB2 plays for some major (and some minor) organizations when they do e-business, and what features in DB2 are e-business features. Lightyear Consulting, of Scottsdale, Arizona specializes in DB2, CICS, IMS and OS/390 consulting. They are recent winners of the first Annual IBM Beacon Award for Best Managing Technology Solution. Click here for the story.
|
|
| RevealNet News |
 | TUSC and RevealNet form Partnership
RevealNet Products Identified as Valuable Knowledge-Transfer Tools |
ROCKVILLE, MD - April 3, 2000 -- RevealNet, developer of knowledge-based solutions, and TUSC, a recognized leader in Oracle consulting, today announced a three-year technology and reseller partnership. RevealNet will supply TUSC's consultants with its complete line of Oracle Knowledge Bases and development tools. TUSC, in turn, will demonstrate and make RevealNet products available for resale through its distribution channels. Click Here for the announcement. |
 | Sylvain Faust and RevealNet Expand Partnership
RevealNet Knowledge Bases Now Integrated with SQL-Programmer IX |
ROCKVILLE, MD - April 10, 2000 -- RevealNet, developer of knowledge-based solutions, and Sylvain Faust Intl., developer of award-winning database solutions, today announced the integration of RevealNet's Knowledge Bases with Sylvain Faust's SQL-Programmer IX. Effective immediately, RevealNet Knowledge Bases will be available for general resale through Sylvain Faust's distribution channels. Click here for more.
|
| RevealNet Launches "Active PL/SQL Knowledge Base" |
RevealNet is pleased to announce the availability of the "Active PL/SQL Knowledge Base" - a new product that helps developers fully utilize and extend the functionality of the PL/SQL language.
The Active PL/SQL Knowledge Base combines a complete PL/SQL Knowledge Base with an extensive PL/SQL Code Library. This powerful combination delivers leading-edge technical expertise, coupled with a vast library of production-ready procedures and functions. At just $295 per developer, this product answers 70-80% of your daily questions and saves countless hours of research, coding and implementation time. Click Here for more information.
|
| Recent Headlines |
|
| Past Issues of the Pipeline Newsletter |
|
|
Current Product Releases