Re: Triggers in Oracle

Eric Chu (ericc_at_ucsee.EECS.Berkeley.EDU) wrote:

> 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

Oracle provides database triggers too. Look into the PL/SQL reference and it will tell you how to build procedure packages and how to build a database trigger at before/after insert/delete/update event on a table.

Cheers,
Judy Received on Tue Feb 08 1994 - 21:22:49 CET