SQL*Plus console, column widths with selects
In a server manager console session I can use charwidth (e.g. SET CHARWIDTH 20) to control the width of columns from the output of a select statement. Can someone please tell me what is the equivalent in an SQL*Plus console session. E.G. I am selecting from dba_users and because the last column EXTERNAL_NAME column is VARCHAR2(4000) therefore the subsequent wrapping messes up the output. Setting linesize only works to a point. The SET CHARWIDTH command is not recognised as a valid command in sqlplus it seems (console version).
Click Here to Expand Forum to Full Width