Re: Triggers source code

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Fri, 23 Apr 2004 11:55:08 +0200
Message-ID: <c6apct$a0gvn$1@ID-93924.news.uni-berlin.de>

"Chris" <Chris.Heitheker_at_lhsystems.com> schrieb im Newsbeitrag news:58379ff7.0404230119.5062b3eb_at_posting.google.com...
> Hiya,
> Could someone tell mme where i can find source code for triggers, ie
> in wich sys view they are stored?

in the Data Dictionary:
SELECT trigger_body FROM USER_TRIGGERS
WHERE TRIGGER_NAME like 'mytrigger%';

more details on http://tahiti.oracle.com

> Alternatively if someone has scripts to extract triggerss, stored
> procs etc from the DB id very much appreciate it.
> Thanks,
> Chris

Many nice things out there, just try google, You will find useful things.

hth, Jan Received on Fri Apr 23 2004 - 04:55:08 CDT