When I do a basic query in SQL plus with a column of type VARCHAR2(100),
it reserves a width of 100 characters for displaying the results in. All of my
queries that include such columns have wrapped around text that is difficult to read.
I'm now using 8.1.6, but I remember when I used an older version, it would automatically
choose column widths for the display that corresponded to the maximum length
of the strings being displayed in the column. I know I can make a report, but that is
complicated. In the old version I could just do "select firstName, lastName from MyUsers" and
it would look good since no user had an extremely long name.
I'm hoping there is just some simple setting for SQL-plus that will let me have it
look the way it did in the older version.
Start Free Trial
