Change Value Column size for show parameters in sqlplus
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.