Personal Knowledge Base
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment