find a column or table in a stored procedure or function 1

[cappmgr]

Is there a way to find a column or table in all off the procs and functions in a database? I was thinking about spooling all of the source code into a file and then parsing but I was hoping for a better way?
tyvm,
Marty

 

[ajayarora]

Hi,

a) To search the table names , you can query all_dependencies table and
b) To search for a particular column you should query all_source table like

select name,text
from all_source
where text like '%column_name%'.

I hope it helps.

Regards

 

[jee]

If what you want to do is search your procedures/triggers for references to certain tables and or columns (not sure I understand what you want)...

If you happen to have access to the TOAD tool, you can search all procedures/functions/packages and/or triggers for specified strings - so you could use that feature to locate references to a table.

Other tools may have similar functions.