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: 373
Registered: July 2013
Location: www.Orafaq.com/Forum
Senior Member
kindly please tell how to search the package object_type from all_objects.
thanks

Report message to a moderator

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: 373
Registered: July 2013
Location: www.Orafaq.com/Forum
Senior Member
admin kindly delete this topic i got the answer.
i.e select * from all_ojects
where object_type='PACKAGE'

Report message to a moderator

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: 68645
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.

Report message to a moderator

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: 373
Registered: July 2013
Location: www.Orafaq.com/Forum
Senior Member
ok sir Smile

Report message to a moderator

Previous Topic: how to check the details of any function or procedure etc
Next Topic: Convert number to CHAR
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 07:37:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.