set lines 300 column name format a40 column value format a30 column MOD_SES format a9 column MOD_SYS format a9 column description format a40 select name,value,ISSES_MODIFIABLE MOD_SES,ISSYS_MODIFIABLE MOD_SYS,ISMODIFIED,ISADJUSTED ADJUSTED,description from v$parameter where upper(name) LIKE upper('%&1%') escape '/' order by name; undefine &&1