Re: How to retrieve function metadata?

From: Pavel Vetesnik <Pavel.Vet_at_volny.cz>
Date: Mon, 22 Sep 2003 10:09:49 +0200
Message-ID: <bkmanr$1dah$1@ns.felk.cvut.cz>

Hi Aswin,

I don't know exact answer to your question, but I guess that the information you are looking for is somewhere within data dictionary. Take a look at http://www.ss64.com/orad/, where is big list of them (here it is for version 8.1.6).

For example for sequences you may get the info calling

---

select * from all_sequences where sequence_name='my_sequence';

---

But I don't know what table or view returns the values you wrote below.

HTH,
Pavel

"Ashwin K Gudidevuni" <ashwin21_99_at_hotmail.com> píše v diskusním příspěvku news:vmt8hu3ampofec_at_corp.supernews.com...
> Hi,
>
> I wanted to know, how to retrieve information about the functions.
> Information like functions return type, its parameters and data type of
its
> parameters, If its and aggregate function or not. If it belongs to any
> category of functions. Is there any schema defined to retrieve these
values
> like Information_Schema.Parameters in Sql Server. If someone can help me
by
> pointing to the right source...
>
> Thank you in advance.
> Ashwin.
>
>
Received on Mon Sep 22 2003 - 03:09:49 CDT