Proceed as follows:
SQL> SET LONG 100000
SQL> select trigger_body from dba_triggers where trigger_name = 'NAME';
Here NAME stands for the trigger that you want to display. You can set LONG to any higher value if your trigger code is very long.
Last Wiki Answer Submitted: May 13, 2004 8:29 am by 170519660 pts.