Re: Trigger or StoreProc Code
From: Bliss <bliss_is_ignorance_at_hotmail.com>
Date: Mon, 3 Dec 2001 20:10:07 +0800
Message-ID: <3c0b6b80_2_at_news.tm.net.my>
Date: Mon, 3 Dec 2001 20:10:07 +0800
Message-ID: <3c0b6b80_2_at_news.tm.net.my>
Hi,
To view the code of triggers..
SQL> select trigger_body
from user_triggers where trigger_name = 'NAME OF TRIGGER';
trigger_body is a long field... so remember to set long... e.g.
SQL> set long 300
To view the code of procedures
SQL> select source
from user_source where name = 'NAME OF PROCEDURE';
to alter these you'll have to extract the source and then alter like any normal trigger / procedure...
Hope this helps...
Regards,
Bliss
To view stored
"Kenny Mak" <tcmak_at_hkstar.com> wrote in message
news:9ucvmv$93v4_at_imsp212.netvigator.com...
> Hello,
> I want to ask how can i alter or view the code of the trigger and
> storeProce
> Thanks a lot again
>
>
>
Received on Mon Dec 03 2001 - 13:10:07 CET