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

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What do you mean "find"?

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ALL_OBJECTS

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

Previous Topic: update
Next Topic: Packages
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 13 23:21:48 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.