RE: How to find PL/SQL code

From: Geeta Iyer <geeta.iyer_at_sprintparanet.com>
Date: Thu, 10 Aug 2000 12:27:07 -0600
Message-Id: <10585.114285@fatcity.com>

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_at_SprintParanet.com

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>How to find PL/SQL code</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN=20
class=3D019022518-10082000>Jeff,</DIV>
<DIV><SPAN=20
class=3D019022518-10082000> </DIV>
<DIV>
set heading =

off</FONT></P>


<P><FONT color=3D#0000ff face=3DArial size=3D2>set feedback =

off</FONT></P>


<P><FONT color=3D#0000ff face=3DArial size=3D2>set linesize =

100</FONT></P>

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..
<SPAN=20
class=3D019022518-10082000> 
Geeta Iyer Sprint Enterprise Network =
Services Work: =20
(303)220-4788 Pager:  888-632-2718 E-Mail:=20 Geeta.Iyer_at_SprintParanet.com </DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
 <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr>-----Original Message----- From: root_at_fatcity.com=20 [mailto:root_at_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 </DIV>
 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. Received on Thu Aug 10 2000 - 13:27:07 CDT