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

Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question

GeekInterview.com > Interview Questions > Database > Stored Procedures

Go To First | Previous Question | Next Question

Stored Procedures | Question 6 of 12

Print

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

Total Answers and Comments: 5

Last Update: July 12, 2008 Asked by: Suman-Delhi

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

February 16, 2007 01:56:06

#1

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

March 10, 2008 03:51:31

#2

Member Since: February 2008 Contribution: 279

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

#3

krishnaindia2007

Member Since: September 2007 Contribution: 870

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

#4

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

#5

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

Sponsored Links

Sponsored Links

Related Categories

—

About Us | Privacy Policy | Terms and Conditions | Contact | Site Map | Add Question | Propose Category | RSS Feeds | Articles Sitemap | Site Updates | Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved