Home » SQL & PL/SQL » SQL & PL/SQL » Find out Object name (Oracle 10g)
Find out Object name [message #443498] Tue, 16 February 2010 01:37 Go to next message
mamalik
Messages: 266
Registered: November 2008
Location: Pakistan
Senior Member

Dear All,

I want to find out the name of objects like procedures,functions which are using a specific column of table.

for example i have a table 'Orafaq' which has column 'Iss_Ide', i want to know which objects like procedures,functions,views are using column "Iss_Ide" of table orafaq


Regards.
Asif.

[Updated on: Tue, 16 February 2010 01:46]

Report message to a moderator

Re: Find out table name [message #443503 is a reply to message #443498] Tue, 16 February 2010 01:46 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle does not expose dependency tracking at column level, just at object level (table, view, package...) (see dba_dependencies), so you have to create your source syntax analyzer.

Regards
Michel
Re: Find out Object name [message #443508 is a reply to message #443498] Tue, 16 February 2010 01:51 Go to previous messageGo to next message
mamalik
Messages: 266
Registered: November 2008
Location: Pakistan
Senior Member

Thanks a lot Michle Uncle.

How can i ceate my source syntax analyzer?

Regards.
Asif.

[Updated on: Tue, 16 February 2010 01:51]

Report message to a moderator

Re: Find out Object name [message #443511 is a reply to message #443508] Tue, 16 February 2010 01:52 Go to previous message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How can i ceate my source syntax analyzer.

Like any other program, think, specify, write code, test...

Regards
Michel
Previous Topic: Sequence generation help
Next Topic: select date values from a table between two dates (merged)
Goto Forum:
  


Current Time: Thu Sep 29 07:22:10 CDT 2016

Total time taken to generate the page: 0.13209 seconds