Home » SQL & PL/SQL » SQL & PL/SQL » how to select all packages (UNIX)
how to select all packages [message #415859] Wed, 29 July 2009 09:54 Go to next message
anasser
Messages: 8
Registered: July 2009
Junior Member

Hi all
I want make select statement to select all packages
any one can help my pleas

Re: how to select all packages [message #415860 is a reply to message #415859] Wed, 29 July 2009 09:56 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
SELECT * FROM all_objects WHERE object_type = 'PACKAGE';
Re: how to select all packages [message #415872 is a reply to message #415859] Wed, 29 July 2009 10:31 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/t/148133/102589/

Regards
Michel
Previous Topic: DBMS_JOB.SUMBIT not working
Next Topic: how to replace string against some key_value table?
Goto Forum:
  


Current Time: Fri Dec 02 21:04:08 CST 2016

Total time taken to generate the page: 0.13059 seconds