Home » SQL & PL/SQL » SQL & PL/SQL » tables being used in packages or procedures........... (9i)
tables being used in packages or procedures........... [message #328887] Mon, 23 June 2008 04:30 Go to next message
singh.neerajin
Messages: 26
Registered: April 2008
Location: noida
Junior Member

Is there nay query or can we join two or more sub queries to retreive the which TABLES being used inside in which procedures or packages ?

or

which procedures are being used in which packages?

Actually i want to create the metadata for the user objects thats why i need a single query through which I can retrive dependency of one object on another one.


Neeraj Singh
Re: tables being used in packages or procedures........... [message #328892 is a reply to message #328887] Mon, 23 June 2008 04:41 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Have a look at the USER_DEPENDENCIES (or ALL_ or DBA_)
Re: tables being used in packages or procedures........... [message #328894 is a reply to message #328887] Mon, 23 June 2008 04:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
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: tables being used in packages or procedures........... [message #328919 is a reply to message #328892] Mon, 23 June 2008 05:52 Go to previous messageGo to next message
singh.neerajin
Messages: 26
Registered: April 2008
Location: noida
Junior Member

thanks
Re: tables being used in packages or procedures........... [message #328920 is a reply to message #328919] Mon, 23 June 2008 05:56 Go to previous message
Olivia
Messages: 519
Registered: June 2008
Senior Member
http://www.orafaq.com/forum/m/326644/125380/#msg_326644
Previous Topic: Update SQL scripts
Next Topic: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Goto Forum:
  


Current Time: Tue Dec 06 15:56:56 CST 2016

Total time taken to generate the page: 0.08851 seconds