|
|
 | 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
"Grants & Revokes"
Author: Daniel Clamage
Clamage Computer ConsultingThe grants.sql and revokes.sql files contain the definitions of two procedures, grants and revokes. The grants procedure grants the specified object privileges to one or all objects in this user's schema of a given type to the given user (grantee). The revokes procedure revokes the specified object privileges from one or all objects in this user's schema of a given type to the given user (revokee). Both the grants/revokes scripts support roles and PUBLIC.
|
Tips of the Month
DB2 Tip of the Month
Author: Craig Mullins
Providing Security via Dataset Passwords
|
| 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 - "Shutdown Immediate" in the Configuration Management Conference. When do you use SHUTDOWN IMMEDIATE, and when do you use SHUTDOWN ABORT?
- PL/SQL Pipeline - "And the Winners Are..." in the Bugs, Curiosities and Workarounds Conference. Pipeliners Steve Cosner, Mark Fredericks and Daniel Clamage tackle a peculiar problem.
|
| Pipeliner of the Month: Daniel Clamage
Dan "If you haven't crashed the Server, you haven't been trying hard enough" Clamage is a devoted member of the Pipelines. He first logged on in September, 1997, and has since posted over 700 messages. Dan is the author of this month's Code Archive. He has also written the PL/SQL content for 2 books by MacMillan Computer Publishing and Que Publishing. Dan and his wife Robin live in the Pittsburgh area and are proud parents of Patty and newborn Daniele Nancy Ann Clamage. Congratulations! |
| Call for Authors
Do you have a flair for writing? Are you camping on a white paper, presentation, code archive or solution/workaround you would like to share with your Oracle and DB2 colleagues around the world? Do you crave worldwide recognition?
At RevealNet, we strongly encourage the sharing of technical information on our "Pipeline Newsletter". So, if you would like to see your name in lights, please e-mail your submission to info@revealnet.com. As a humble gesture of our thanks, we will acknowledge the author or each accepted article, and mail him/her a stylish RevealNet baseball cap.
|
| 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.
|
|
|
The Oracle Library Cache is a mechanism that allows users to share and reuse SQL statements and PL/SQL objects, as well as other less common objects. This article, written by John Beresniewicz, technical product manager of Savant Corporation and frequent Pipeline contributor, helps clarify the essential purpose of the Oracle library cache, and provides insights for DBAs from a tuning perspective. Click here for the article. |
Type 2 indexes provide numerous benefits to a DB2 subsystem. The primary benefit is the elimination of index locking. With DB2 Version 6, Type 1 indexes are eliminated altogether, so you will be forced to move to Type 2 indexes. This paper addresses the storage impact of migration from Type 1 to Type 2 indexes.Click here for Craig's paper.
|
You can spend all day tuning your SQL statements. It is difficult to find detailed, comprehensive recommendations for tuning the PL/SQL side of one's Oracle applications. After spending 12 years learning, using and writing about Oracle's PL/SQL language, Steven Feuerstein has assembled 1,247 tuning tips for PL/SQL developers. This presentation reviews some of the most entertaining of these tips. Click here for the presentation.
|
|
| RevealNet Product News |
 | RevealNet Spring Releases Available 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 IOUG-A May 8-10 in Anaheim, CA for a sneak preview. |
|
| RevealNet Partner News |
 | Savant and RevealNet Form Technology Partnership
Partnership to Advance the Automation of DBA Knowledge |
BETHESDA & ROCKVILLE, MD - May 1, 2000 --Savant Corporation, developer of enterprise performance management solutions, and RevealNet, developer of knowledge-based solutions, today announced plans to integrate RevealNet's Oracle Knowledge Bases with Savant Enterprise - Oracle Edition. Effective immediately, Savant Corporation will offer RevealNet products as add-ons to Savant products, further extending Savant's commitment to automating DBA knowledge. The partnership enables customers to benefit from Savant and RevealNet Oracle database expertise. Future plans call for Savant and RevealNet to work together to create a dynamic knowledge environment with Savant products.Click here for more information.
|
| 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