-
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).
Many thanks
Gus
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|