Message-Id: <10585.114285@fatcity.com> From: "Geeta Iyer" Date: Thu, 10 Aug 2000 12:27:07 -0600 Subject: RE: How to find PL/SQL code This is a multi-part message in MIME format. ------=_NextPart_000_000F_01C002C6.4C4C41A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit How to find PL/SQL codeJeff, set heading off set feedback off set linesize 100 set pagesize 0 break on name skip 10 spool exportStoredProceduresOnly.txt select decode (line,1,'create or replace '||text,text) from sys.dba_source where owner='&Owner' order by owner,name,type,line; spool off Hope this helps.. Geeta Iyer Sprint Enterprise Network Services Work: (303)220-4788 Pager: 888-632-2718 E-Mail: Geeta.Iyer@SprintParanet.com -----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Jeff Wiegand Sent: Thursday, August 10, 2000 9:45 AM To: Multiple recipients of list ORACLE-L Subject: 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 ------=_NextPart_000_000F_01C002C6.4C4C41A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How to find PL/SQL code
Jeff,
 

set heading = off

set feedback = off

set linesize = 100

set pagesize 0

break on name skip = 10

spool=20 exportStoredProceduresOnly.txt

select decode = (line,1,'create or=20 replace '||text,text)

from = sys.dba_source

where = owner=3D'&Owner'

order by=20 owner,name,type,line;

spool off

 

Hope=20 this helps..

 

Geeta Iyer
Sprint Enterprise Network = Services
Work: =20 (303)220-4788
Pager:  888-632-2718
E-Mail:=20 Geeta.Iyer@SprintParanet.com

-----Original Message-----
From: root@fatcity.com=20 [mailto:root@fatcity.com]On Behalf Of Jeff = Wiegand
Sent:=20 Thursday, August 10, 2000 9:45 AM
To: Multiple recipients of = list=20 ORACLE-L
Subject: 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 it?

Thanks for your help.