i needing find references table's field, , have hundreds of stored procedures search through. goal find being used in clauses , add value in statement. example, where mytable.field_x in (1,2,3) needs become mytable.field_x in (1,2,3,4) . so i'm curious if there system table, dba_dependencies, or can query show me procs, views, or functions referencing field? can give. what version of oracle using? if using @ least 11.1, introduced column-level dependency tracking, , you're not afraid leverage undocumented data dictionary tables, can create dba_dependency_columns view give information. show every piece of code depends on column not column used in where clause of statement. you can search dba_source text of procedures, functions, , triggers code has sort of where clause. gets little tricky, though-- if put list of values on different line or if there inline view column name aliased else, can tricky find via text search. views, you'd need ...