| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to find PL/SQL code
the trigger_body column is a LONG column... so in sqlplus do
set long 20000
and then select the trigger_body column from user_triggers or dba_triggers
you may have to adjust the number...
another way is to do a full database export, rows=n
then do an import with show=y and a log file -- the trigger code will be captured in the log of the show
Rachel
>From: David Barbour <DBarbour_at_connectsouth.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: How to find PL/SQL code
>Date: Thu, 10 Aug 2000 15:19:34 -0800
>
>Jeff,
>
>If the triggers are in a stored procedure, you can get the text from either
>dba_source or user_source.
>
>
>David A. Barbour
>Oracle DBA - ConnectSouth
>512-681-9438
>dbarbour_at_connectsouth.com
>
>-----Original Message-----
>Sent: Thursday, August 10, 2000 10:45 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>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
>
 |
 |