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.
Register Hereor login if you are already a member