Re: Trigger or StoreProc Code

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