Re: Trigger information

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 11 Nov 2003 04:25:23 -0800
Message-ID: <1a75df45.0311110425.85861a9@posting.google.com>

"Ermanno" <ececca_at_amsjv.it> wrote

> Is it possible know SQL statement that cause trigger execution and read it
> from particular system view ?

SQL> descr user_source

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 NAME                                               VARCHAR2(30)
 TYPE                                               VARCHAR2(12)
 LINE                                               NUMBER
 TEXT                                               VARCHAR2(4000)

The TYPE values are:
FUNCTION
JAVA SOURCE
PACKAGE
PACKAGE BODY
PROCEDURE
TRIGGER
TYPE
TYPE BODY

--
Billy

Received on Tue Nov 11 2003 - 06:25:23 CST