Message-Id: <10585.114276@fatcity.com> From: "Wayne S Bellefeuille" Date: Thu, 10 Aug 2000 11:27:56 -0500 Subject: Re:How to find PL/SQL code It is in trigger_body in user_triggers. The reason only part of it comes out is that you have your SQLPLUS "long" set too low. Type the following: SQL> set long 10000 SQL> select trigger_body from user_triggers; Wayne Bellefeuille Talent Software Services ____________________Reply Separator____________________ Subject: How to find PL/SQL code Author: Date: 8/10/00 7:44 AM Hello We have several triggers that have been modified. Unfortunately, the modifications weren't saved, but they are reflected in the database. How can I get Oracle to output the code of the triggers. I select on user_triggers, or all_triggers, using trigger_name and trigger_body columns, but only part of the code is outputted to the screen. How can I get all of it? Thanks for your help. Jeff How to find PL/SQL code

Hello

We have several triggers that have been modified. Unfortunately, the modifications weren't saved, but they are reflected in the database. How can I get Oracle to output the code of the triggers. I select on user_triggers, or all_triggers, using trigger_name and trigger_body columns, but only part of the code is outputted to the screen. How can I get all of it?

Thanks for your help.

Jeff