Re: built-in functions

Are books too old-fashioned ?

The paperback

Oracle Desk Reference
The Professional's Companion
from Prentice Hall PTR Oracle Series

is my constant desktop accessory - it has everything you want, I believe, and while not electronic, is very fast to use..

pntva_at_yahoo.com (underground_covert_IT_operations) wrote:

>I think this is pretty much what I need. Somebody else suggested
>another query which also seems to work fine:
>
>select unique object_name
>from all_arguments
>where package_name = 'STANDARD'
>
>However, the problem is that commonly used function "MAX" does not
>appear in the result produced by the query above and by the query that
>you have given below.
>
>Basically, I am looking for sql statement(s) that would:
>
>1) get the names of all built-in functions (including commonly used
>functions such as MAX, MIN).
>
>2) given the name of a function, return the number and type of
>arguments that the function takes as input.
>
>Seems like its a pain in oracle to get a simple list of all built-in
>functions along with commonly used once. And I am just looking for
>funtions right now, later on I need to do the same with stored
>procedures, user functions, and pl/sql packages.
>
>Thanks,
>
>-- Pinto
>
>
>"Roman Mirzaitov" <rmirzaitov_at_kt.kg> wrote in message news:<ap81ak$s81at$1_at_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,

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Oct 25 2002 - 14:20:43 CDT