Re: built-in functions

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Thu, 24 Oct 2002 11:43:08 +0600
Message-ID: <ap81ak$s81at$1@ID-127142.news.dfncis.de>

Hi,

select text
from dba_source
where name='STANDARD'
and text like ' function%'
and (substr(text,12,1)<>'''' and substr(text,12,1)<>'"') order by 1

You can add more conditions to get exactly you need. Or I didn't understand you correctly?

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com


"underground_covert_IT_operations" <pntva_at_yahoo.com> wrote in message
news:2b5f60b4.0210231618.6dcb9f5f_at_posting.google.com...


> Hello,

>

> Does oracle have a system table where all the names of built-in

> function is stored. I need to get a list of all the built-in function

> supported in oracle database on-the-fly and programmatically.

>

> Thanks,

Received on Thu Oct 24 2002 - 00:43:08 CDT