how to find out the package name and table name which use a column name " check_column" in Oracle
Posted on 2011-02-14
i have to find out the package name and table name which use the column name "check_column" in Oracle.
because the data type of this column has been changed, so have to check all the package ,procedure and function would afacte it .
select * from dba_tab_columns
select * from dba_source
is there any quick method to debug, because it involves a lot of package?