/* ************************************************ */
/*                                                  */
/* Script: Display vales for the database parms     */
/*                                                  */
/* run: @C:\rkupcuna05_ora\Oracle\SQL\v_parame.sql  */
/* date:    24-AUG-95                               */
/* creator: Rick Kupcunas                           */
/*                                                  */
/* ************************************************ */

set pagesize 65;
set linesize 80;

col name format a35
col value format a20
col xdefault format a9

spool v_parame.rslt;

select substr(name, 1, 35)     name,
     substr(value, 1, 20)      value,
     substr(isdefault, 1, 9)   xDEFAULT
from v$parameter
order by 1,2,3;

commit;
spool off;

