select
  FUNC_ID,                                 -- FUNC_ID NUMBER
  NAME,                                    -- NAME VARCHAR2(30)
  MINARGS,                                 -- MINARGS NUMBER
  MAXARGS,                                 -- MAXARGS NUMBER
  DATATYPE,                                -- DATATYPE VARCHAR2(8)
  VERSION,                                 -- VERSION VARCHAR2(12)
  ANALYTIC,                                -- ANALYTIC VARCHAR2(3)
  AGGREGATE,                               -- AGGREGATE VARCHAR2(3)
  OFFLOADABLE,                             -- OFFLOADABLE VARCHAR2(3)
  DISP_TYPE,                               -- DISP_TYPE VARCHAR2(13)
  USAGE,                                   -- USAGE VARCHAR2(30)
  DESCR                                    -- DESCR VARCHAR2(4000)
from
  GV$SQLFN_METADATA
where
  inst_id=USERENV('Instance')