Home » SQL & PL/SQL » SQL & PL/SQL » How to get procedure script from dictioinary table
How to get procedure script from dictioinary table [message #202868] Mon, 13 November 2006 02:19 Go to next message
freethinking
Messages: 10
Registered: November 2006
Junior Member
hi dear all , who can tell me which dictionary table i can used to get script of a procedure
for example, I want find a table 'emp' is used by which procedure

many thanks ...
Re: How to get procedure script from dictioinary table [message #202870 is a reply to message #202868] Mon, 13 November 2006 02:24 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
user_source/all_source/dba_source
user_dependencies
Re: How to get procedure script from dictioinary table [message #202872 is a reply to message #202868] Mon, 13 November 2006 02:27 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Untested, but I believe that user_dependencies can help here:
select name
     , type
from   user_dependencies
where  referenced_name = 'EMP'
and    referenced_type = 'TABLE'
and    referenced_owner = 'SCOTT'
/
MHE
icon7.gif  Re: How to get procedure script from dictioinary table [message #202878 is a reply to message #202868] Mon, 13 November 2006 02:39 Go to previous message
freethinking
Messages: 10
Registered: November 2006
Junior Member
It's great , I spend two hours to find out which dictionary table I can use ,but I failed Smile,thank you two again

Regards
Previous Topic: Kindly rewrite this code
Next Topic: ORA-06592
Goto Forum:
  


Current Time: Thu Dec 08 20:27:58 CST 2016

Total time taken to generate the page: 0.13404 seconds