select table_name, column_name from all_tab_columns where column_name like 'X%'

Place your column Name in the place of 'X'