Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to reduce the width of NAME field in SQL*Plus

james_pFeb 27 2023

SQL*Plus/Oracle Database version: 19.11

OS : RHEL 7.x

When doing a describe of V$DATABASE or V$SESSION, etc views, I cannot seem to reduce the width of NAME column as shown in the below screenshot. This makes the output a bit unreadable

I tried setting the following in SQL*Plus. No luck. I think these settings used to work in 10g, 11g SQL*Plus.

SQL> column NAME_COL_PLUS_SHOW_PARAM format a35

SQL> col "Name" for a35

Any workaround ?

This post has been answered by Julian Frey-CITE on Feb 27 2023

Jump to Answer

Added on Feb 27 2023

4 comments

174 views