Re: Triggers in Oracle

In article <2ish06$h18_at_agate.berkeley.edu>, ericc_at_ucsee.EECS.Berkeley.EDU (Eric Chu) writes:
|>
|> Having been an Ingres user for a while, I'm used to being able to
|> create rules and procedures which act as triggers whenever a table is
|> updated, records inserted, etc.
|> However, I can't really figure out how to do the same in Oracle.. Is there
|> something analogous to 'create rule' and 'create procedure' in Oracle?
|> All I want to do is store some control information in the table whenever
|> a record is added or updated and I'd prefer to do this through a trigger
|> rather than at the application level.
|> Thanks.
|>
|> Eric Chu
|> ericc_at_ucsee.eecs.berkeley.edu
|>
|>

Depends on the version of Oracle that you are using. Database-stored triggers became available with version 7 of Oracle. Version 6 does not have them.

-- 
Derek Fields
(derek_at_gamekeeper.bellcore.com)