Hi,
I have one Oracle standalone procedure.In this am doing truncating the data and loading the new data into the target table.
The issue is , I want to know whether the table is callable from other procedure,if it it callable I want to know the Procedure or Packages list.
and want to know the related child tables from the system table?
Is it possible to write any program for this? Please share your ideas...