Home » SQL & PL/SQL » SQL & PL/SQL » Dependent procedures on a table
Dependent procedures on a table [message #325162] Thu, 05 June 2008 03:55 Go to next message
thisisnatesh
Messages: 92
Registered: March 2007
Member
Hi

How do we find out dependent procedures/functions
of a table?

Thanks in Advance
Natesh
Re: Dependent procedures on a table [message #325165 is a reply to message #325162] Thu, 05 June 2008 03:59 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
USER/ALL/DBA_DEPENDENCIES
Re: Dependent procedures on a table [message #325168 is a reply to message #325162] Thu, 05 June 2008 04:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=1236
http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=1237

Regards
Michel
Re: Dependent procedures on a table [message #325170 is a reply to message #325162] Thu, 05 June 2008 04:17 Go to previous messageGo to next message
mintomohan
Messages: 104
Registered: November 2006
Location: India
Senior Member
SELECT * FROM user_dependencies WHERE referenced_name= '&table_name';


Regards
Minto
Re: Dependent procedures on a table [message #325179 is a reply to message #325170] Thu, 05 June 2008 04:32 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This does NOT add anything from the previous post.

Regards
Michel
Previous Topic: SQLLDR : Remove ^M
Next Topic: sql query problem
Goto Forum:
  


Current Time: Wed Dec 07 03:05:39 CST 2016

Total time taken to generate the page: 0.06751 seconds