SQL*Plus query result columns don't line up

From: Steve Mitchell <stevem_at_hdcsi.com>
Date: Thu, 15 Aug 2002 15:34:41 GMT
Message-ID: <lSP69.57$bq3.9342107_at_newssvr14.news.prodigy.com>

[Quoted] [Quoted] I am using 9i client SQLplus against an 8i database. I am using Windows XP [Quoted] (and have also had this problem with Windows 2000).

[Quoted] [Quoted] 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 [Quoted] 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 [Quoted] the results. For example, the SALESPERSINNAMEIDX column doesn't line up properly:

[Quoted] 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 [Quoted] 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 Received on Thu Aug 15 2002 - 17:34:41 CEST