Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to capture SQL_TEXT of queries?

Re: How to capture SQL_TEXT of queries?

From: Donne You <dy_at_gomez.physics.lsa.umich.edu>
Date: 1997/04/10
Message-ID: <5ihnon$ndr@lastactionhero.rs.itd.umich.edu>#1/1

In article <334AB6CD.5C17_at_castle.net> Jim Jenkinson <jjenkins_at_castle.net> writes:
>I am told by my oracle rep that Oracle 8 will include a new type of
>trigger which fires on a SELECT. I believe it will be called an 'INSTEAD
>OF' trigger, because it will allow the trigger to alter the selected
>data before it is returned to the user (allowing masking of columns,
>changing of values, etc.)
>
>Has anyone heard similar information?

'instead of' trigger still fires on insert,update,or delete. but it's created on a view instead of table. this allows DMLs against a join view. the trigger is responsible for maintaining the underlying tables. never heard of SELECT triggers.

Don Received on Thu Apr 10 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US