You can use view all_triggers or user_triggers to get the entire text. trigger_body has the trigger text. triggering_event, trigger_type , REFERENCING_NAMES etc have other details. You can also use enterprise manager to get it. One trick in enterprise manager is to add some spaces somewhere (a non change) in the trigger and hit 'show sql'. that will give u the whole sql. Verify and try it. Good luck.
Oracle DBA <[EMAIL PROTECTED]> wrote:
Hi List,
Could you please help me to get the source code of
the trigger without using any third party tools?
Thanks in advance,
Raj
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Oracle DBA
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list y! ou want to be removed from). You may
also send the HELP command for other information (like subscribing).
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
