Re: Viewing source code of a trigger

From: Peter Schneider <peter.schneider_at_okay.net>
Date: Tue, 01 Sep 1998 20:39:13 GMT
Message-ID: <6shm1t$6us$2@trader.ipf.de>

robertch_at_mindspring.com (Robert Chung) wrote:

>I need to take a look at the source code of a particular trigger that
>is slowing down our database big time. I am trying to see the code
>using TRIGGER$ data dictionary view. However, this table displays
>only a couple of lines of the code and does not let you see the rest
>of the code. Is there some other way to see the code? (possibly with
>other data dictionary view?) Thank you in advance.

Hi Robert,

in SQL*Plus, try this:

SET LONG 30000
SELECT trigger_body
FROM user_triggers
WHERE trigger_name = '<your_trigger_name>';

HTH,
Peter

--
Peter Schneider
peter.schneider_at_okay.net Received on Tue Sep 01 1998 - 15:39:13 CDT