Database Software

I write this query to know about the existing indexes of all tables pertains to a schema. My problem is when index is functional one, column name is not descriptive, it is like SYS_NC00047$, ..... as yet i could not find the way to know exact column name in the out put of this query. your help is required..

 SELECT index_owner,
         index_name,
         table_owner,
         table_name,
         column_name,
         column_position,
         column_length
    FROM dba_ind_columns
   WHERE index_owner = 'CORE_BUSINESS'
ORDER BY table_name               ;