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: 64729
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: Fri Apr 28 14:58:26 CDT 2017

Total time taken to generate the page: 0.18834 seconds