Message-Id: <10585.114265@fatcity.com> From: Jeff Wiegand Date: Thu, 10 Aug 2000 09:41:48 -0500 Subject: How to find PL/SQL code This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C002D9.1DBEE150 Content-Type: text/plain; charset="iso-8859-1" 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 ------_=_NextPart_001_01C002D9.1DBEE150 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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