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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Viewing source code of a trigger

Re: Viewing source code of a trigger

From: Madhu Cherukuri <madhuc_at_hotmail.com>
Date: 1 Sep 1998 00:27:51 GMT
Message-ID: <6sff27$r25@bgtnsc03.worldnet.att.net>


Look at SYS.DBA_TRIGGERS
You should find code in that table

Madhu Cherukuri

Robert Chung wrote in message <35eb1354.33711214_at_news.mindspring.com>...
>
>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.
>
>
Received on Mon Aug 31 1998 - 19:27:51 CDT

Original text of this message

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