select
  name,
  value,
  to_char( 
    case
      when type=1 then 'boolean'
      when type=2 then 'varcher'
      when type=3 then 'number'
      when type=4 then 'file'
      else             'etc'
    end) type,
  isses_modifiable,
  issys_modifiable,
--  ismodified,
--  isadjusted,
  description
  from v$parameter2
order by name
