Home » RDBMS Server » Server Administration » Find proc name
Find proc name [message #52848] Fri, 16 August 2002 09:49 Go to next message
Eugene
Messages: 44
Registered: August 2001
Member
Hi,
I want to find a procedure that uses a table name in question. Is there a way to do so?
For instance I have 100 procs and I am looking for a table customer in any one of them.

Thanks

Report message to a moderator

Re: Find proc name [message #52849 is a reply to message #52848] Fri, 16 August 2002 10:30 Go to previous message
Radek
Messages: 33
Registered: April 2002
Member
try
select name from user_dependencies where
REFERENCED_NAME ='your_table'
and type='PROCEDURE'

Cheers,
Radek

Report message to a moderator

Previous Topic: Re: Oracle 7 to Oracle 8
Next Topic: end-of-file on communication channel for remote database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 10:47:21 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.