query

[sougata1]

is there a way by which we can know that "A PARTICULAR FIELD(COLUMN)
OCCURS IN WHICH ALL TABLES"
hope my question is clear....

[milonov]

If I got you right this querry is useful for you:

select t.table_name from sys.all_tab_col s t where t.column_name = 'your_column_na me'

this select gives you the list of tables with column 'your_column_na me'

or you can filter tables, using expression like

select t.table_name from sys.all_tab_col s t where t.column_name = 'your_column_na me' and t.table_name='t able_name1' and t.table_name='t able_name2'...

Best Regards,
Michael Milonov

http://www.snotratech.com

is there a way by which we can know that "A PARTICULAR FIELD(COLUMN)
OCCURS IN WHICH ALL TABLES"
hope my question is clear....

[lavanyavijayan]

is there a way by which we can know that "A PARTICULAR FIELD(COLUMN)
OCCURS IN WHICH ALL TABLES"
hope my question is clear....

Hi,
try the following query to get answer ...

select table_name from user_tab_column s where COLUMN_NAME='&C ol_name'

Here you just enter the column name you want to search

-Vijayan.