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

From: <Christopher.Jones_at_oracle.comX>
Date: 16 Aug 2002 12:00:13 +1000
Message-ID: <uk7mr36mq.fsf_at_oracle.comX>


[Quoted] "Steve Mitchell" <stevem_at_hdcsi.com> writes:

> 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

Have the default SQL*Plus font registry entries been changed? Are the default System fonts installed correctly?

Chris

-- 
Christopher Jones, Oracle Corporation, Australia.
Received on Fri Aug 16 2002 - 04:00:13 CEST

Original text of this message