Home » SQL & PL/SQL » SQL & PL/SQL » Dependent objects (oracle 10g)
Dependent objects [message #440136] Thu, 21 January 2010 05:11 Go to next message
ravi214u
Messages: 153
Registered: February 2008
Location: CANADA
Senior Member

hi,

how to identify the dependency, how many tables are used in a package and inside package we have functins too. So what is the best way to trace all the tables used in one package including the function which are called in the package.

thanks
Re: Dependent objects [message #440137 is a reply to message #440136] Thu, 21 January 2010 05:12 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Its a faq search before posting.


Dependent objects
sriram Smile

[Updated on: Thu, 21 January 2010 05:19]

Report message to a moderator

Re: Dependent objects [message #440142 is a reply to message #440137] Thu, 21 January 2010 05:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
And just below http://www.orafaq.com/forum/mv/msg/153487/436776/102589/#msg_436776

Regards
Michel
Re: Dependent objects [message #440145 is a reply to message #440142] Thu, 21 January 2010 05:32 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Nice link which is one of the replies of the link posted By me Wink

sriram Smile Razz

[Updated on: Thu, 21 January 2010 05:32]

Report message to a moderator

Re: Dependent objects [message #440148 is a reply to message #440145] Thu, 21 January 2010 05:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I know it (and this is why I said "and just below") but I pointed it because most of the time people just read the post you point to and not the whole topic.

Regards
Michel
Re: Dependent objects [message #440149 is a reply to message #440148] Thu, 21 January 2010 05:40 Go to previous message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Yes...Even i like the Links too(as i commented there!)

i am Just pointing it thats it nothing else..
Sriram Smile
Previous Topic: invalid group by query
Next Topic: Exception handling
Goto Forum:
  


Current Time: Thu Feb 06 14:38:04 CST 2025