Home » SQL & PL/SQL » SQL & PL/SQL » how to find all packages and procedures form user_objects
how to find all packages and procedures form user_objects [message #262117] Fri, 24 August 2007 10:22 Go to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member


this query will return
select view_name from user_views
all views from user_views .I want to know similarly can I find all packages, procedures ?
Miro
Re: how to find all packages and procedures form user_objects [message #262119 is a reply to message #262117] Fri, 24 August 2007 10:26 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
query user_objects.

Regards
Michel
Previous Topic: Oracle function within a subquery
Next Topic: ORA-00942 table or view does not exist
Goto Forum:
  


Current Time: Thu Dec 08 08:13:21 CST 2016

Total time taken to generate the page: 0.10838 seconds