Home » SQL & PL/SQL » SQL & PL/SQL » Query to find all the column references.. (Oracle 10.2.0.3.0)
Query to find all the column references.. [message #405395] Wed, 27 May 2009 09:38 Go to next message
oracle123
Messages: 56
Registered: March 2009
Member
Hi all,

I want to know all the package/procedure/function references to a column(salary) in a table(emp).

I tried looking at different data dictionary views but did not find any helpful.

Please help me in resolving this.

Thanks,
Scott.
Re: Query to find all the column references.. [message #405397 is a reply to message #405395] Wed, 27 May 2009 09:39 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
Which views did you look at? and what queries did you run to look at them?
Re: Query to find all the column references.. [message #405398 is a reply to message #405395] Wed, 27 May 2009 09:41 Go to previous messageGo to next message
cookiemonster
Messages: 12421
Registered: September 2008
Location: Rainy Manchester
Senior Member
I don't believe oracle stores column level dependencies prior to 11g.
Re: Query to find all the column references.. [message #405403 is a reply to message #405395] Wed, 27 May 2009 10:01 Go to previous messageGo to next message
oracle123
Messages: 56
Registered: March 2009
Member
Cookiemonster,

It would be helpful even if I can trace out the table level dependency.

Thanks.

Pablolee ,

I looked at the definitions of different data dictionary views, especially all_*/dba_*/user_* views.

Thanks,
Scott.
Re: Query to find all the column references.. [message #405404 is a reply to message #405395] Wed, 27 May 2009 10:05 Go to previous messageGo to next message
cookiemonster
Messages: 12421
Registered: September 2008
Location: Rainy Manchester
Senior Member
all_dependencies
Re: Query to find all the column references.. [message #405411 is a reply to message #405404] Wed, 27 May 2009 10:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
cookiemonster wrote on Wed, 27 May 2009 17:05
all_dependencies

That does not track at column level.

Regards
Michel

Re: Query to find all the column references.. [message #405413 is a reply to message #405395] Wed, 27 May 2009 10:21 Go to previous messageGo to next message
oracle123
Messages: 56
Registered: March 2009
Member
Cookiemonster,

Just for knowledge purpose, how to find the column level dependencies in 11g?

Thanks,
Scott.
Re: Query to find all the column references.. [message #405417 is a reply to message #405395] Wed, 27 May 2009 10:27 Go to previous messageGo to next message
cookiemonster
Messages: 12421
Registered: September 2008
Location: Rainy Manchester
Senior Member
@Michel

I know. OP went on to ask for table level.

@oracle123

Pass. Don't have 11g handy - check the new features guide.
Re: Query to find all the column references.. [message #405421 is a reply to message #405417] Wed, 27 May 2009 10:46 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
cookiemonster wrote on Wed, 27 May 2009 17:27
@Michel

I know. OP went on to ask for table level.

@oracle123

Pass. Don't have 11g handy - check the new features guide

Sorry didn't see his last answer.

In 11g, column level dependency is not in catalog views but in sys.dependency$.d_attrs (if you are able to decypher it).

Regards
Michel

[Updated on: Wed, 27 May 2009 10:47]

Report message to a moderator

Previous Topic: Exists condition
Next Topic: last value/count before fetch from refcursor
Goto Forum:
  


Current Time: Thu Dec 08 08:48:27 CST 2016

Total time taken to generate the page: 0.20506 seconds