Re: Get the name of a trigger
From: Don Fraser <don_at_clear.net.nz>
Date: 1997/11/10
Message-ID: <646o8s$5uk_at_granny.mac.co.nz>#1/1
Date: 1997/11/10
Message-ID: <646o8s$5uk_at_granny.mac.co.nz>#1/1
Bureau IIB2 Nantes Tour Bretagne wrote in message
<3463B263.37C3_at_dial.oleane.com>...
>Hello every one,
>I'm looking for a method to get the name of a trigger in a PL/SQL
>module.
>Is it possible ?
>Please help.
is this what you want?
This will give you a list of all triggers and the tables they reference. You can add a condition to find the table you want and the names of triggers that depend on it.
select DEP.NAME, DEP.REFERENCED_NAME from
user_objects OBJ
, user_dependencies DEP
where
DEP.NAME = OBJ.OBJECT_NAME
AND OBJ.object_type = 'TRIGGER'
AND DEP.REFERENCED_TYPE = 'TABLE'
Received on Mon Nov 10 1997 - 00:00:00 CET