How do I find a table that uses column name using column name?

[BoHyun Jung]

if table A, B use column name(ex) user_name)

How do I find table A,B using column name(ex) user_name)

[Basheer]

Go to sys_dictionary table.

There search for the column name 

open the records with the name and you can find the table name.