select
  NUM,                                     -- NUM NUMBER
  NAME,                                    -- NAME VARCHAR2(80)
  TYPE,                                    -- TYPE NUMBER
  VALUE,                                   -- VALUE VARCHAR2(4000)
  DISPLAY_VALUE,                           -- DISPLAY_VALUE VARCHAR2(4000)
  ISDEFAULT,                               -- ISDEFAULT VARCHAR2(6)
  ISSES_MODIFIABLE,                        -- ISSES_MODIFIABLE VARCHAR2(5)
  ISSYS_MODIFIABLE,                        -- ISSYS_MODIFIABLE VARCHAR2(9)
  ISINSTANCE_MODIFIABLE,                   -- ISINSTANCE_MODIFIABLE VARCHAR2(5)
  ISMODIFIED,                              -- ISMODIFIED VARCHAR2(10)
  ISADJUSTED,                              -- ISADJUSTED VARCHAR2(5)
  ISDEPRECATED,                            -- ISDEPRECATED VARCHAR2(5)
  ISBASIC,                                 -- ISBASIC VARCHAR2(5)
  DESCRIPTION,                             -- DESCRIPTION VARCHAR2(255)
  ORDINAL,                                 -- ORDINAL NUMBER
  UPDATE_COMMENT                           -- UPDATE_COMMENT VARCHAR2(255)
from
  GV$PARAMETER2
where
  inst_id = USERENV('Instance')