DB Parameter change generation script

-- ---------------------------------
--
-- DB Parameter change generation script
--
--
-- ---------------------------------

col name format a30 word_wrapped
col description format a60 word_wrapped
def param = &&1
set verify off

select decode(ISSES_MODIFIABLE,'FALSE','Cannot be changed','TRUE','Can be changed') "Session",
   decode(ISSYS_MODIFIABLE,'FALSE','Cannot be changed','TRUE','Can be changed','IMMEDIATE','Can be changed immdeiate','DEFERRED','Can be changed deferred') "System",
   'ALTER SYSTEM SET '||name||' = '||value||' scope='||
decode(ISSYS_MODIFIABLE,'FALSE','spfile','IMMEDIATE','both or memory',ISSYS_MODIFIABLE)||' sid=''*'';' value
from v$parameter
where name like ('%&param%')
or value like ('%&param%')
/

undef param
undef 1
set verify on