Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting Stored Proc from Oracle 8.0.5
In article <920j04$ul1$1_at_nnrp1.deja.com>,
stemp1ar_at_my-deja.com wrote:
> Is there any other way using SQLPLUS to get the source code for a
> stored procedure and retrieve only the 1 procedure requested...
> Currently using: SELECT text FROM ALL_SOURCE WHERE owner = USER; will
> give all of the procedures not just 1 requested...
>
> Sent via Deja.com
> http://www.deja.com/
>
There are a series of 3rd party tools that work well --
BMC SQLProgrammer $150.00 and $1000 depending on parts. Quest SQLNavigator $900 to $1500 ( I think ) Quest TOAD ??
Shareware version of TOAD : www.toadsoft.com $FREE or next to it
There are others...
Most can be downloaded in trial or complete form.
-- Michael Krolewski Rosetta Inpharmatics mkrolewski_at_rii.com Usual disclaimers Sent via Deja.com http://www.deja.com/Received on Fri Dec 22 2000 - 16:42:22 CST