text: ﻿-- All Parameters.sql
  
  select name "Paramater_Name", 
  	   decode(type, 1, 'Boolean',
  					2, 'String',
  					3, 'Integer',
  					4, 'Parameter file',
  					5, 'Reserved',
  					6, 'Big Integer') type,
  	   value "Value",
  	   isdefault "Default",
  	   isses_modifiable "Session_Modifiable",
  	   issys_modifiable "System_Modifiable",
  	   description "Description"
    from v$parameter
   where substr(name, 1, 2) != '__'
   order by name;
  