Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to find PL/SQL code

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><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D019022518-10082000>Jeff,</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D019022518-10082000></SPAN></FONT>&nbsp;</DIV>
<DIV><SPAN class=3D019022518-10082000>
<P><FONT color=3D#0000ff face=3DArial size=3D2>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>

<P><FONT color=3D#0000ff face=3DArial size=3D2>set pagesize 0</FONT></P>
<P><FONT color=3D#0000ff face=3DArial size=3D2>break on name skip =
10</FONT></P>
<P><FONT color=3D#0000ff face=3DArial size=3D2>spool=20
exportStoredProceduresOnly.txt</FONT></P>
<P><FONT color=3D#0000ff face=3DArial size=3D2>select decode =
(line,1,'create or=20
replace '||text,text)</FONT></P>
<P><FONT color=3D#0000ff face=3DArial size=3D2>from =
sys.dba_source</FONT></P>
<P><FONT color=3D#0000ff face=3DArial size=3D2>where =
owner=3D'&amp;Owner'</FONT></P>
<P><FONT color=3D#0000ff face=3DArial size=3D2>order by=20
owner,name,type,line;</FONT></P>
<P><FONT color=3D#0000ff face=3DArial size=3D2>spool off</FONT></P>
<P>&nbsp;</P>
<P><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D019022518-10082000>Hope=20
this helps..</SPAN></FONT></P>
<P><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D019022518-10082000></SPAN></FONT>&nbsp;</P><FONT color=3D#0000ff = face=3DArial=20
size=3D2><SPAN class=3D019022518-10082000>
<P><FONT size=3D2>Geeta Iyer<BR>Sprint Enterprise Network =
Services<BR>Work:&nbsp;=20
(303)220-4788<BR>Pager:&nbsp; 888-632-2718<BR>E-Mail:=20 Geeta.Iyer_at_SprintParanet.com<BR></FONT></P></SPAN></FONT></SPAN></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
  <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20   [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Jeff = Wiegand<BR><B>Sent:</B>=20
  Thursday, August 10, 2000 9:45 AM<BR><B>To:</B> Multiple recipients of = list=20
  ORACLE-L<BR><B>Subject:</B> How to find PL/SQL = code<BR><BR></DIV></FONT>
  <P><FONT size=3D2>Hello</FONT> </P>
  <P><FONT size=3D2>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?</FONT></P>
  <P><FONT size=3D2>Thanks for your help.</FONT> </P> Received on Thu Aug 10 2000 - 13:27:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US