Easiest bet is to use any one of the gui tools available,
such as Toad, or Procedure Builder, etc...
hth,
Yosi
-Original Message-
From: Ron Rogers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 5:07 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: SQL Command
Valerie,
The text for the procedures are stored in the dba_source tables. Set your environment
to a longer line and select the text where name = procedure.
ROR mm
[EMAIL PROTECTED] 04/03/01 04:35PM
What is the SQL command, v$ table or SQL*Plus command to see the contents of
a stored
Title: RE: SQL Command to view stored procedure
-Original Message-
From: Webber Valerie H [mailto:[EMAIL PROTECTED]]
What is the SQL command, v$ table or SQL*Plus command to
see the contents of a stored
procedure?
I looked at DBA_SOURCE but it stored the code in
separate rows based