Home » SQL & PL/SQL » SQL & PL/SQL » SQL: Listing/Showing functions created by "CREATE function"?
SQL: Listing/Showing functions created by "CREATE function"? [message #316311] Thu, 24 April 2008 10:36 Go to next message
oraktan
Messages: 2
Registered: April 2008
Junior Member
Does anyone know how to list functions created? I do a create function and can use it, but I would just list a listing of all the functions that exist. Any help?
Re: SQL: Listing/Showing functions created by "CREATE function"? [message #316312 is a reply to message #316311] Thu, 24 April 2008 10:39 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
look at the all_objects dd view

[Updated on: Thu, 24 April 2008 10:39]

Report message to a moderator

Re: SQL: Listing/Showing functions created by "CREATE function"? [message #316313 is a reply to message #316312] Thu, 24 April 2008 10:41 Go to previous messageGo to next message
oraktan
Messages: 2
Registered: April 2008
Junior Member
DD? View? What does that mean? I really am a newbie.
Re: SQL: Listing/Showing functions created by "CREATE function"? [message #316319 is a reply to message #316313] Thu, 24 April 2008 10:55 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Check this link.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2005.htm#i1583352

Regards

Raj
Re: SQL: Listing/Showing functions created by "CREATE function"? [message #316330 is a reply to message #316313] Thu, 24 April 2008 11:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
View: Master Glossary: http://www.oracle.com/pls/db102/master_glossary?letter=V&category=#index-VI
DD: Data Dictionary (and if you don't what it is, see above glossary)

Regards
Michel
Re: SQL: Listing/Showing functions created by "CREATE function"? [message #316372 is a reply to message #316313] Thu, 24 April 2008 17:04 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
oraktan wrote on Thu, 24 April 2008 16:41
DD? View? What does that mean? I really am a newbie.

You can create a function, yet you are not familiar with the concept of a view?! Hmm
Previous Topic: SQL Plus script question
Next Topic: Piping results of an sql insert into a 2nd insert statement
Goto Forum:
  


Current Time: Sun Dec 04 04:23:02 CST 2016

Total time taken to generate the page: 0.05285 seconds