List Of Oracle Functions Available 1

[Sridharan]

Hello All,

Is it possible to get a list of all Oracle Functions from Oracle Database??? Is there any table where all the supported functions of a particular Oracle Database Version is stored???

Any help will be highly appreciated!

Thanks
Sridharan

 

[sem]

select object_name, owner from dba_objects where object_type='FUNCTION' Regards, Dima

 

[Sridharan]

Hi Dima,

Thanks for your reply!. Your query gives me the User Defined Functions In Oracle. But what I require is a way to get List Of All Built In Oracle Functions eg. like Sum, Count, Decode etc.???

Thanks

Sridharan

 

[sem]

Sum, count, decode and some other functions are SQL (not pl/sql) functions and implemented within SQL engine, thus are hidden. Some common functions (e.g. substr, to_char etc) are in SYS.STANDARD package. As for other Oracle's system functions, you may list them by limiting query by "and owner='sys'" Regards, Dima

 

[shiongss]

Hi,

How to see the content of SYS.STANDARD package?

Thanks.

 

[sem]

You may issue DESC command from sql*plus. This will provide formatted output. You may also get the source of package by:

select text from all_source where type='PACKAGE' and name='STANDARD' and owner='SYS' order by line Regards, Dima