Home » SQL & PL/SQL » SQL & PL/SQL » How to write query for this (Oracl10g)
How to write query for this [message #399583] Thu, 23 April 2009 01:40 Go to next message
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
Member

Hi,
I have to write query ,
when i will perfrom any alteration on table..I have to find out all the dependant object realted to that table.Can you tell me how can i get this dependant information.
including -Tables,Procedures,functions, Packages, triggers etc.
Re: How to write query for this [message #399584 is a reply to message #399583] Thu, 23 April 2009 01:43 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Are you bragging or complaining?
Either you can or you can;t.
Show us you can!
Re: How to write query for this [message #399585 is a reply to message #399583] Thu, 23 April 2009 01:43 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
user_dependencies

Regards
Michel
Previous Topic: Database Link Insert with Function
Next Topic: ORA-01873: the leading precision of the interval is too small
Goto Forum:
  


Current Time: Mon Dec 05 21:36:06 CST 2016

Total time taken to generate the page: 0.06034 seconds