Re: Is there a Database event that occurs when a row is inserted/updated in a table?

Home -> Community -> Usenet -> c.d.o.server -> Re: Is there a Database event that occurs when a row is inserted/updated in a table?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 10 Feb 2004 13:38:59 -0000
Message-ID: <4028def4$0$7061$ed9e5944@reading.news.pipex.net>

Hi Jack

FWIW I'm not aware of *any* RDBMS that does this. I'm not quite as convinced as you of the need either.

Advantages of Triggers:
Can be before or after insert
Can be row or statement level
Can be disabled/enabled
Are a stable and mature technology
Fire no matter what application is getting at the data.

Advantages of Database Events
Might have to write less code.(would have to rewrite for every app that might access the db though)
Have a choice of programming languages.

I can't really construct a compelling case as you can see.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
"Jack Wright" <sunil_at_volcanomail.com> wrote in message
news:8f556eeb.0402100303.524e53e8_at_posting.google.com...


> I would prefer Oracle to implement/expose such events in future...I

> guess it will not be too far when there will be database events that

> will be able to do this...

>

> Many Regards

> Jack

>

> rjamadagni_at_hotmail.com (Raj Jamadagni) wrote in message

news:<76772c3f.0402091002.6d054f66_at_posting.google.com>...


> > And with some clever select statement, you can "generate" trigger code

> > for any table that you want.

> >

> > Raj

Received on Tue Feb 10 2004 - 07:38:59 CST