Re: Trigger or StoreProc Code
From: LakshmiNarasimhan <rlnsimha2000_at_yahoo.com>
Date: 3 Dec 2001 05:18:16 -0800
Message-ID: <c0f5d7ed.0112030518.33475040_at_posting.google.com>
Date: 3 Dec 2001 05:18:16 -0800
Message-ID: <c0f5d7ed.0112030518.33475040_at_posting.google.com>
"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
HI
U need script to be stored for maintenance purpose of Stored procedure and trigger for any future modification / updations.
Or If u r using Dev2000 , then open d2k, go to database objects in the
navigator, select ur schema / Trigger or storee procedure double
click, pl sql editor will open with ur code and u can do the
modification and save there.
this is an easiest way since it will check ur code also.
Received on Mon Dec 03 2001 - 14:18:16 CET