Re: SQL*Plus query result columns don't line up

Read the SqlPLus docs regarding the
column and heading and linesize and other 'setable' variables ( or settings since they are not technically variables)

"Steve Mitchell" <stevem_at_hdcsi.com> wrote:

>I am using 9i client SQLplus against an 8i database. I am using Windows XP
>(and have also had this problem with Windows 2000).
>
>I am running sqlplus from the command line. My cmd.exe window is
>set to with a screen buffer size width of 1000 and a height of 4000. My
>sqlplus login script sets my linesize to 999.
>
>Here is the problem: When sqlplus prints the results of a query, it will
>often mess up the position of the column headers, and the data in the
>columns. It is not predictable (to me) and can vary from row to row within
>the results. For example, the SALESPERSINNAMEIDX column doesn't line up
>properly:
>
>CUSTNAMEIDX CURRENCYIDX CUSTPOREF CMCLSTGSHIPP SALESPERSONNAMEIDX
>----------- ----------- ---------- ------------ ------------------
> 754 1 753
>
>Sometimes it's not just the data, but also the headers that don't line up
>properly (such that the '---' beneath the column name doesn't line up with
>the column name itself or the data).
>
>This often shows for columns that appear in a table after another column
>which is VARCHAR(80 or more).
>
>Makes my queries very hard to read. Has anybody else seen this? Know how
>it can be fixed?
>
>Thanks for any pointers.
>
>--steve
>
>
>
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Thu Aug 15 2002 - 18:25:38 CEST