Re: SQL*Plus query result columns don't line up (more info)

Here is more info regarding my question below. Version information:

  SQL*Plus: Release 9.2.0.1.0 - Production on Thu Aug 15 08:21:56 2002   Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.   Connected to:
  Oracle8i Release 8.1.7.1.1 - Production   JServer Release 8.1.7.1.1 - Production

And another example. Note how the QNT column header and data do not line up properly, then how GASETLAMT column header doesn't line up, but the data is fine.. Confused.

PRODUCTIDX NAMEIDX GABLOCKIDX ICQNT QNT GASETLAMT ---------- ---------- ---------- ---------- ---------- ----------

     55373                    117        200     200        2109.1
     55373                    117         50      50        527.28
     55373                    117        200     200       2109.07
     55373                    117        100     100       1054.55

--steve

"Steve Mitchell" <stevem_at_hdcsi.com> wrote in message news:lSP69.57$bq3.9342107_at_newssvr14.news.prodigy.com...
> 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
>
>
>
>
>
Received on Thu Aug 15 2002 - 17:50:23 CEST