set lines 300 column name format a40 column display_value format a30 column MOD_SES format a9 column MOD_SYS format a9 column description format a40 select name,display_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