Return to Articles Page

White Papers and notes by Edward Stoever
=====================|=================================================================
Jun 30, 2006         | PL/SQL Class example - create a massive scema with meaningful data!
                     |
Jun 20, 2006         | Unable to create a database using dbca - it quits! (RH Linux 3.0)
                     |
Apr 19, 2006         | Using MERGE INTO to populate a table with complex queries 
                     |
Apr 12, 2006         | Use Oracle to get IP Address and Host Name of local or remote hosts!
                     |
Mar 16, 2006         | Turn the results of an Oracle Query into an excel spreadsheet
                     |
Feb 3, 2006          | Sample Questions for 10g Certification
                     |
Dec 13, 2005         | A simplified Excel Macro for exporting to a CSV file
                     |
Nov 9, 2005          | Build the Oracle HR Sample Schema from a script 
                     |
Oct 20, 2005         | Create an Oracle SQL Script that will Accept a Password
                     |
Oct 6, 2005          | Oracle's User Defined Aggregate Functions
                     |
Nov 17, 2005         | Full Banner 6 Install on Redhat Linux
                     |
Oct 6, 2005          | Passing bash variables to SQLPLUS
                     |
Oct 5, 2005          | isnumeric function
                     |
Jul 1, 2005          | Effective RMAN script
                     |
Apr 29, 2005         | Find the Slow SQL statements and the (ad-hoc) users who run them!
                     |
Apr 26, 2005         | Create a script on the OS for each object returned by a query
                     |
Apr 13, 2005         | Find users whose passwords match usernames
                     |
Apr 12, 2005         | Trap system error information to a table
                     |
Apr 6, 2005          | An Excel Macro that saves the cells into a text file for SQLLOADER
                     |
Apr 4, 2005          | My Create-RMAN-Script view
                     |
Mar 17, 2005         | Move LOBS and CLOBS to their own tablespace to prevent fragmentation
                     |
Feb 28, 2005         | Custom Auditing
                     |
Feb 24, 2005         | Using PL/SQL Web Toolkit to show the browser's IP Address
                     |
Feb 14, 2005         | Use PL/SQL to create a dynamic webpage with encrypted HTML source!
                     |
Feb 9, 2005          | Query log tables and email the results to the DBA
                     |
Jan 12, 2005         | Create a trigger on a mutating table that prevents date overlapping
                     |
Nov 29, 2004         | My CREATE-BACKUP-SCRIPT view
                     |
Nov 17, 2004         | Create and use PL/SQL Table variables
                     |
Oct 21, 2004         | A script for building a script to debug objects that don't compile
                     |
Sep 20, 2004         | Using decode to determine Greater than and Less than
                     |
Sep 20, 2004         | My BUFFER-POOL-HITS view
                     |
Sep 15, 2004         | Logical table deassingment on VMS after shutdown abort
                     |
Sep 13, 2004         | My BUFFER-CACHE-HIT-RATIO view
                     |
Aug 18, 2004         | My GRANTED-CREATE-SESSION view
                     |
Aug 17, 2004         | Log all sessions with system triggers
                     |
Aug 17, 2004         | Repopulate a table with a query that writes inserts
                     |
July 15, 2004        | Create sessions for custom web applications in PL/SQL
                     |
May 2004             | Install Oracle9i on Alpha Open VMS - notes
                     |
May 30, 2004         | Oracle's UTL Scripts
                     |
May 28, 2004         | Recompiling all objects after import from 8i to 9i on VMS					 
                     |
April 8, 2004        | Package to Flatten Query Results to a single string
                     |
March 23, 2004       | Keep Extent growth under control
                     |
March 14, 2004       | Create Custom Banner Forms (PDF File 110k)
=====================|=================================================================

Some of my older material:

Script for causing load on system for testing backup & recovery or other scenarios

Query_load.... major load on a server from many different queries... very cool!

Offline backup Script

Auto build a backup script and a sample of the script that is built

Create a table with serious row chaining... and fix it!

Using Flashback Query to recover lost rows! Cool!

Materialized View

Install OracleForms6i so it connects with an Oracle9i Database

Use ORADIM to create a new instance.

What the heck is a bind variable anyway???

Making use of dbms_space

Analyze every object in your schema once per day!