Oracle: DBA_INDEXTYPES

select
   ixt.owner,
   ixt.indextype_name,
   ixt.implementation_schema,
   ixt.implementation_name,
   ixt.number_of_operators,
   typ.typecode,
   typ.type_oid,
   ixt.partitioning,
   ixt.array_dml,
   ixt.maintenance_type,
   ixt.interface_version,
   ixt.implementation_version
from
   dba_indextypes ixt                                                       left join
   dba_types      typ on ixt.implementation_schema  = typ.owner     and
                         ixt.implementation_name    = typ.type_name
;