Stored Procedures - How do you find which procedures are being used in database?

GeekInterview.com > Interview Questions > Database > Stored Procedures

Go To First | Previous Question | Next Question

Stored Procedures | Question 6 of 12

How do you find which procedures are being used in database?

Total Answers and Comments: 6

Last Update: March 12, 2009 Asked by: Suman-Delhi

Sponsored Links

Best Rated Answer

—

Submitted by: sippsin

select procedure_name from all_procedures

Above answer was rated as good by the following members:
sandeep549

February 16, 2007 01:56:06

sippsin

Member Since: June 2006 Contribution: 6

RE: How do you find which procedures are being used in...

select procedure_name from all_procedures

Is this answer useful? Yes | No

1 0

Overall Rating: +1

March 10, 2008 03:51:31

sampra

Member Since: February 2008 Contribution: 278

RE: How do you find which procedures are being used in database?

select procedure_name from all_procedures

Is this answer useful? Yes | No

May 26, 2008 00:19:23

krishnaindia2007

Member Since: September 2007 Contribution: 854

RE: How do you find which procedures are being used in database?

I think all_procedures shows you the list of procedures you have access to but not that are used in database.

Is this answer useful? Yes | No

June 01, 2008 09:53:23

raheemrao

Member Since: May 2008 Contribution: 2

RE: How do you find which procedures are being used in database?

select proc_name from user_procedures;

Is this answer useful? Yes | No

July 12, 2008 05:23:04

aparna_mhatre84

Member Since: July 2008 Contribution: 1

RE: How do you find which procedures are being used in database?

select object_name from user_objects where object_type 'PROCEDURE'

Is this answer useful? Yes | No

March 12, 2009 02:29:35

himanshu D silva

Member Since: March 2009 Contribution: 2

RE: How do you find which procedures are being used in database?

sp_helptext procname will tell you if the procedure is existed or not as it will show you the whole syntax of that procedure.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank