Re: How to get a Function out of the database

user_source tells you:

SQL> desc user_source                         
 Name                  Null?    Type          
 --------------------- -------- --------------
 NAME                           VARCHAR2(30)  
 TYPE                           VARCHAR2(12)  
 LINE                           NUMBER        
 TEXT                           VARCHAR2(4000)

gets the name and type of function/procedure etc, as well as the text that makes it up.

Keld Nielsen wrote:
>
> Robert: user_source ??
>
> Rachel: I would recommend toad www.quest.com
>
> as for the graphical tool question, then toad has some, so does designer,
> and so does ...
> It surely depends on your requirements and $
> Regards,
> Keld
>
> "Robert Malikian" <malikian_at_malikian.homechoce.co.uk> wrote in message
> news:3c656427_at_news1.homechoice.co.uk...
> > Look in USER_SOURCE and you will find what you want.
> > Robert
> > "rachel cox" <cox_at_evo.org> wrote in message
> > news:a70c7020.0202090833.6c1c861b_at_posting.google.com...
> > > Hi,
> > >
> > > I created a function in one database, and stupidly forgot to keep the
> > > exact copy
> > > of the function. Now I would like to get it out. Is there any way for
> > > me to find out the exact description of the function using sqlplus?
> > >
> > > In other questions, what's the best graphical tool for viewing an
> > > oracle database?
> > >
> > > Thanks!
> > > rachel
> >
> >
Received on Sat Feb 09 2002 - 22:24:13 CET