select column_name , case data_type when 'NUMBER' then data_type||' ('||data_precision || case when data_scale != '0' then ','||data_scale else '' end ||')' when 'VARCHAR2' then data_type||' ('||data_length||' '||case char_used when 'B' then 'Byte' when 'C' then 'Char' end ||')' when 'DATE' then data_type end datatype , case nullable when 'N' then 'Not Null' else '' end nullable from user_tab_columns where table_name = 'MMK_MIXMATCHES' order by column_id;