Home » SQL & PL/SQL » SQL & PL/SQL » How to find procedure or package (oracle 10.2.0.2.0 ,unix)
How to find procedure or package [message #413981] Mon, 20 July 2009 00:52 Go to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member



Hi all,

How to find a procedure or package in oracle from sql prompt?



Thanks and Regards,
Balaji

Re: How to find procedure or package [message #413982 is a reply to message #413981] Mon, 20 July 2009 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you mean "find"?

Regards
Michel
Re: How to find procedure or package [message #413989 is a reply to message #413982] Mon, 20 July 2009 01:08 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member



There might be lots of procedures ,packages etc.. in database .my question is how one can find the particular procedure or package from sql prompt?

Mohan
Re: How to find procedure or package [message #413993 is a reply to message #413989] Mon, 20 July 2009 01:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALL_OBJECTS

Regards
Michel
Re: How to find procedure or package [message #414000 is a reply to message #413993] Mon, 20 July 2009 01:47 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

can i use dba_procedures instead ? what is the difference in both the views?

I created new database and checked with dba_objects and dba_procedures views
to find out the procedures,packages .Here i could see the difference in the output
of both the views.can u explain me on this?

Mohan
Re: How to find procedure or package [message #414009 is a reply to message #414000] Mon, 20 July 2009 02:11 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All views are described in Database Reference

Quote:
Here i could see the difference in the output
of both the views.can u explain me on this?

How should I know as you don't show us what you did nor what you got.
Post it and post it FORMATTED.
And don't use IM speak.

Regards
Michel
Previous Topic: update
Next Topic: Packages
Goto Forum:
  


Current Time: Sun Dec 04 18:40:15 CST 2016

Total time taken to generate the page: 0.07449 seconds