OTN has it in electronic form.
"TurkBear" <john.greco_at_dot.state.mn.us> wrote in message
news:586jru49i1nr64fcoqlb22r7dndrh5bv9v_at_4ax.com...
> 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:48:29 CDT
