Change Value Column size for show parameters in sqlplus

February 23, 2010 at 1:46 pm (Oracle) (, , , )

Ever wondered how to change the Value column size in sqlplus, here it is. The output columns for show parameter are NAME_COL_PLUS_SHOW_PARAM, VALUE_COL_PLUS_SHOW_PARAM and TYPE.

If you try using column VALUE format a60 and use show parameters spfile it would not work because the column name is VALUE_COL_PLUS_SHOW_PARAM
For example,
SQL> set linesize 150
SQL> column VALUE format a60
SQL> show parameters spfile;

NAME TYPE VALUE
———————————— ———– ——————————
spfile string /opt/oracle/products/11gr1/dbs
/spfileCTPD01.ora
SQL>

The following uses column VALUE_COL_PLUS_SHOW_PARAM format to set the size.

SQL> set linesize 150
SQL> column VALUE_COL_PLUS_SHOW_PARAM format a60
SQL> show parameters spfile;

NAME TYPE VALUE
———————————— ———– ————————————————————
spfile string /opt/oracle/products/11gr1/dbs/spfileCTPD01.ora

As displayed above, the entire row is displayed as a single line.

Permalink Leave a Comment