|
|
 | 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
"Unload a Record to be a SQL Insert Statement"
By Sean CassidyThis procedure accepts a table name as well as schema name and WHERE clause. It then generates an INSERT statement for that table and each row identified by the WHERE clause. Output is generated with DBMS_OUTPUT.PUT_LINE.
|
Tips of the Month
|
| Discussions of the Month
Visit RevealNet's Pipelines for "Pipe Talk" - active discussions with your colleagues from around the world.
- DBA Pipeline - "Avoiding Users from Giving Commit" in the Oracle Security section
- PL/SQL Pipeline - "Tuning: Does order of a PK column in a SELECT matter in the speed of the query" in the Debugging, Tracing, and Tuning section.
|
| Pipeliner of the Month: Darryl Hurley
Darryl submitted an excellent two-part paper on the Oracle8i Log Miner facility. Stay tuned next month for part 2.RevealNet actively encourages the submission of white papers, tips, code archives, etc. for publication in this newsletter or our internet Pipeline forums. If we publish your article, you will receive a handsome, embroidered RevealNet cap, plus possible "Pipeliner of the Month" recognition. |
| 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 I
By Darryl Hurley |
Introduced in version 8.1.5 of Oracle (the database) Log Miner provides a PL/SQL API directly into the labyrinth of Redo Logs. Finally all transactions performed in a database can easily be viewed, recreated, audited or undone. Building custom auditing, logging or undo facilities which often proved to be an applications Achille's heel is no longer required because one can now find out exactly what was done, when it was done and who did it. Click Here for more. |
A trigger is a piece of code that is executed in response to a data modification statement; that is, an insert, update, or delete. To be a bit more precise: triggers are event-driven specialized procedures that are stored in, and managed by the RDBMS. Each trigger is attached to a single, specified table. Triggers can be thought of as an advanced form of "rule" or "constraint" written using an extended form of SQL.
Click Here for more.
|
A transportable tablespace is a self contained tablespace that allows it and its datafiles to be moved from one database to another. For example, a set of data and index tablespaces, where all internal references between tables and indexes are resolved within that set of tablespaces would qualify to be transportable.Click Here for more. |
 | Embarcadero Technologies Integrates Knowledge Bases with DBArtisan & Rapid SQL |
ROCKVILLE, MD - January 31, 2000 -- RevealNet, developer of knowledge-based solutions, and Embarcadero Technologies, Inc., developer of award winning database lifecycle management tools, today announced the integration of RevealNet's Oracle and IBM DB2 Knowledge Bases with Embarcadero's DBArtisan and Rapid SQL software.
"Now Embarcadero's Oracle and IBM DB2 users can readily access the highest quality technical knowledge from top industry experts," said Ellen Taylor, president and CEO of Embarcadero. Click Here for more information. |
| Active PL/SQL Knowledge Base Offers "PL/Vision Pipeline" Support |
One of the most intriguing features of the Active PL/SQL Knowledge Base is PL/Vision - a code library of over 1,000 production-ready PL/SQL functions and procedures with unwrapped source code. In most cases, a single line call to a PL/Vision procedure or function can replace dozens or hundreds of lines of custom coding and debugging. To help customers familiarize themselves with the capabilities of the code library, we have opened the "PL/Vision Pipeline" an internet community for PL/Vision customers. We are loading suggestions and tips for using the code library to replace redundant, low-level coding routines. You can access the PL/Vision Pipeline by downloading the Active PL/SQL Knowledge Base.Click Here to download the Active PL/SQL Knowledge Base.
|
|
Current Product Releases