Thursday, September 8, 2011

search a column references in whole database

if we looking for all reference to a specific column in whole database,we can
execute this:
select table_name, column_name from all_tab_columns where column_name like 'FACILITY_SEQ'
it willlist all tables that reference to column "FACILITY_SEQ"

No comments:

Post a Comment