Whitepapers on Triggers

From: Steven Haas <steven.haas_at_snet.net>
Date: Fri, 08 Nov 2002 08:59:20 -0800
Message-ID: <F001.004FEEAC.20021108085920@fatcity.com>

Listers,

Oracle 8.1.7

I am looking for any whitepaper(s) that can provide guidelines on the creation, use, performance and limitations of triggers.

I need to create triggers on possibly 45 tables for auditing purposes. The first draft
requirements document indicates denormalizing data and generating data for null columns using the triggers (yeah, bad ideas). I prefer to make them as simple as possible and would like to have the best arguments against doing it the way the requirements suggest.

TIA, Steve Haas

"Opinions, real or imagined, are mine."

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Steven Haas
  INET: steven.haas_at_snet.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Nov 08 2002 - 10:59:20 CST