[code]</pre>
set lines 132
col name format a30
col val format a30
col isdefault format a5
col DESCRIPTION format a31 head ‘Description|Update Comment’
col ses_mod format a11 head ‘SessM|sysM’
col mod format a11 head ‘Modifiable|Adjustable’
col adj format a5 head ‘ADJ’
col update_comment format a30
select name,value val,isdefault,
RPAD(ISSES_MODIFIABLE,10)||’ ‘||rpad(ISSYS_MODIFIABLE,10) ses_mod,
RPAD(ISMODIFIED,10)||’ ‘||rpad(ISADJUSTED,10) mod,
rpad(description,30)||’ ‘||update_comment description
from v$parameter2
where name like lower(‘&name%’)
order by 1
/
<pre>[/code]