Message-Id: <10586.114336@fatcity.com> From: Schoen Volker Date: Fri, 11 Aug 2000 11:21:14 +0200 Subject: AW: 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_01C00375.7EE85670 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable try this script, it will generate two sppol-files with ddl for your triggers: =20 spool c:\temp\Trigger1.sql col c1 format a79 word_wrap set long 32000 set arraysize 1 verify off feedback off echo off heading off = timing off prompt REM Generating Triggers =20 select 'create or replace trigger ' c1, description c1, 'WHEN ('||when_clause||')' c1, trigger_body , '/' c1, 'show errors;' c1, 'commit;' c1 from user_triggers where when_clause is not null / spool off =20 spool c:\temp\Trigger2.sql col c1 format a79 word_wrap set long 32000 set arraysize 1 verify off feedback off echo off heading off = timing off prompt REM Generating Triggers select 'create or replace trigger ' c1, description c1, trigger_body , '/' c1, 'show errors;' c1, 'commit;' c1 from user_triggers where when_clause is null / =20 spool off Mit freundlichen Gr=FC=DFen=20 i. V. Volker Sch=F6n=20 E-Mail: mailto:v.schoen@inplan.de =20 http://www.inplan.de =20 -----Urspr=FCngliche Nachricht----- Von: Jeff Wiegand [mailto:jwiegand@ancept.com] Gesendet: Donnerstag, 10. August 2000 17:45 An: Multiple recipients of list ORACLE-L Betreff: How to find PL/SQL code Hello=20 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.=20 Jeff=20 ------_=_NextPart_001_01C00375.7EE85670 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How to find PL/SQL code
try=20 this script, it will generate two sppol-files with ddl for your=20 triggers:
 
spool=20 c:\temp\Trigger1.sql
     col c1 format a79=20 word_wrap
     set long = 32000
    =20 set arraysize 1 verify off feedback off echo off heading off timing=20 off
     prompt REM Generating=20 Triggers
 
     select 'create or = replace=20 trigger '=20 c1,
           = ;=20 description = c1,
          =20 'WHEN ('||when_clause||')'=20 c1,
           = trigger_body=20 ,
          =20 '/'        =20 c1,
           = 'show=20 errors;'  =20 c1,
          =20 'commit;'   c1
     from=20 user_triggers
     where when_clause is not=20 null
/
spool off
 
spool=20 c:\temp\Trigger2.sql
     col c1 format a79=20 word_wrap
     set long = 32000
    =20 set arraysize 1 verify off feedback off echo off heading off timing=20 off
     prompt REM Generating=20 Triggers
     select 'create or replace trigger = '=20 c1,
           = ;=20 description = c1,
          =20 trigger_body = ,
          =20 '/'        =20 c1,
           = 'show=20 errors;'  =20 c1,
          =20 'commit;'   c1
     from=20 user_triggers
     where when_clause is=20 null
/
 
spool=20 off

Mit freundlichen Gr=FC=DFen

i. V. Volker = Sch=F6n
E-Mail: mailto:v.schoen@inplan.de<= /U>=20
http://www.inplan.de

-----Urspr=FCngliche Nachricht-----
Von: Jeff = Wiegand=20 [mailto:jwiegand@ancept.com]
Gesendet: Donnerstag, 10. = August 2000=20 17:45
An: Multiple recipients of list = ORACLE-L
Betreff:=20 How to find PL/SQL code

Hello

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