Home » SQL & PL/SQL » SQL & PL/SQL » how to search the package object_type from all_objects
how to search the package object_type from all_objects [message #608091] Sat, 15 February 2014 04:37 Go to next message
jgjeetu
Messages: 226
Registered: July 2013
Location: India Hindustan
Senior Member
kindly please tell how to search the package object_type from all_objects.
thanks
Re: how to search the package object_type from all_objects [message #608093 is a reply to message #608091] Sat, 15 February 2014 04:50 Go to previous messageGo to next message
jgjeetu
Messages: 226
Registered: July 2013
Location: India Hindustan
Senior Member
admin kindly delete this topic i got the answer.
i.e select * from all_ojects
where object_type='PACKAGE'
Re: how to search the package object_type from all_objects [message #608094 is a reply to message #608093] Sat, 15 February 2014 05:06 Go to previous messageGo to next message
Michel Cadot
Messages: 58934
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Could you please do SEARCH before posting question you can answer yourself in a while.

Re: how to search the package object_type from all_objects [message #608098 is a reply to message #608094] Sat, 15 February 2014 05:51 Go to previous message
jgjeetu
Messages: 226
Registered: July 2013
Location: India Hindustan
Senior Member
ok sir Smile
Previous Topic: how to check the details of any function or procedure etc
Next Topic: Convert number to CHAR
Goto Forum:
  


Current Time: Fri Aug 29 05:36:44 CDT 2014

Total time taken to generate the page: 0.11427 seconds