Hi Team,
Need to find all dependent objects for more than 50 tables. I am getting below issue:
for e.g. for table customer i find all dependent objects using all_dependencies view.
But some dependent packages and procedures contain lot of dynamic queries using customer table. That not coming using all_dependencies view.
Now if i search using dba_source view using below query. it search lot of unnecessary entries. where customer name is there.
select * from all_source where lower(text) like '%customer %';
for e.g. lot of parameters define like v_customer_id or some table name like customer_order or customer_account.
Could anyone suggest best solution for this as I need to find out dependent objects for more than 50 tables.
Thanks in Advance.