Find Tables associated with the corresponding Field name (Oracle)

The following query is used to find the tables associated with corresponding field name select * from user_tab_columns where column_name='FIELDNAME' select * from all_tab_columns where column_name = 'FIELDNAME'