Re: Trigger information

From: mcstock <mcstockspamplug_at_spamdamenquery.com>
Date: Tue, 11 Nov 2003 09:28:26 -0500
Message-ID: <69-dncm-L_fYby2iRVn-vA@comcast.com>

the exact text of the SQL statement is not made available during trigger execution

however what you will know by virtue of the trigger declaration includes:

type of statement (INSERT, UPDATE or DELETE -- may also need to check the INSERTING, UPDATING and DELETING boolean flags) old (original) values of columns (for UPDATE and DELETE) new values of columns (for INSERT and UPDATE) if the trigger has a WHEN condition, which column(s) changed

read up on triggers in the concepts manual and SQL manual

-- 
Mark C. Stock
email mcstock -> enquery(dot)com
www.enquery.com
(888) 512-2048

"Ermanno" <ececca_at_amsjv.it> wrote in message
news:boq2eq$cn8$1_at_e3k.asi.ansaldo.it...


> Is it possible know SQL statement that cause trigger execution and read it

> from particular system view ?

>

> Thanks.

>

> Ermanno

>

>

Received on Tue Nov 11 2003 - 08:28:26 CST