Re: Can you get a description of a function from the Oracle-datadictionary??

Type the following in SQL*Plus:

DESCRIBE function_name

It will list the function parameters.

HTH,
Brian

wybrand wrote:
>
> Hi,
>
> I have the following question: I want to get a description of a
> function like substr or a user defined function from the
> datadictionary. For instance I want to know which datatype the
> function returns and what many in-, out- and in/out parameters the
> function has and of which type they are.
>
> Is this possible??
>
> Thank you in advance.
>
> Greetings,
>
> Wybrand.

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"