select
  o.inst_id,                               -- INST_ID NUMBER
  o.id,                                    -- FUNC_ID NUMBER
  o.name,                                  -- NAME VARCHAR2(30)
  o.operands,                              -- MINARGS NUMBER
  o.maxoperands,                           -- MAXARGS NUMBER
  case                                     -- DATATYPE VARCHAR2(8) 
     when d.ret_type = 0 
     then 'UNKNOWN' 
     when d.ret_type = 1 
     then 'NUMERIC' 
     when d.ret_type = 2 
     then 'STRING' 
     when d.ret_type = 3 
     then 'DATETYPE' 
     when d.ret_type = 4 
     then 'BINARY' 
     when d.ret_type = 5 
     then 'EXPR' 
     when d.ret_type = 6 
     then 'ARG 1' 
     when d.ret_type = 7 
     then 'ARG 2' 
     when d.ret_type = 8 
     then 'ARG 3' 
     else 'INVALID' end,
  case                                     -- VERSION VARCHAR2(12) 
     when v.version = 1 
     then 'V6 Oracle' 
     when v.version = 2 
     then 'SQL/DS' 
     when v.version = 10 
     then 'V71 Oracle' 
     when v.version = 11 
     then 'V73 Oracle' 
     when v.version = 12 
     then 'V80 Oracle' 
     when v.version = 13 
     then 'V81 Oracle' 
     when v.version = 14 
     then 'V816 Oracle' 
     when v.version = 16 
     then 'V82 Oracle' 
     when v.version = 18 
     then 'V92 Oracle' 
     when v.version = 19 
     then 'V10 Oracle' 
     when v.version = 20 
     then 'V10R2 Oracle' 
     when v.version = 21 
     then 'V11R1 Oracle' 
     else 'INVALID' end,
  case                                     -- ANALYTIC VARCHAR2(3) 
     when bitand(o.flags, 4096) = 4096 
     then 'YES' 
     when bitand(o.flags, 32768) = 32768 
     then 'YES' 
     else 'NO' end,
  case                                     -- AGGREGATE VARCHAR2(3) 
     when bitand(o.flags, 8) = 8 
     then 'YES' 
     else 'NO' end,
  decode(                                  -- OFFLOADABLE VARCHAR2(3)
    bitand(o.flags,16777216), 16777216, 'YES', 'NO'),
  case                                     -- DISP_TYPE VARCHAR2(13) 
     when d.disp_type = 0 
     then 'UNKNOWN' 
     when d.disp_type = 1 
     then 'NORMAL' 
     when d.disp_type = 2 
     then 'ARITHMATIC' 
     when d.disp_type = 3 
     then 'PARENTHESIS' 
     when d.disp_type = 4 
     then 'REL-OP' 
     when d.disp_type = 5 
     then 'CASELIKE' 
     when d.disp_type = 6 
     then 'NOPARENTHESIS' 
     else 'INVALID' end,
  d.usg,                                   -- USAGE VARCHAR2(30)
  d.descr                                  -- DESCR VARCHAR2(4000)
from
  x$operators o,
  x$opversion v,
  x$opdesc d
where
  o.indx = v.indx and v.indx = d.indx and o.inst_id = v.inst_id and v.inst_id = d.inst_id