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

For whoever may also experience this problem. I finally solved it with

set tab off

Thanks to all those who replied.

--steve

"Steve Mitchell" <stevem_at_hdcsi.com> wrote in message news:dT879.5605$k_1.279599426_at_newssvr13.news.prodigy.com...
>
> I have tried using both Lucida Console and "Raster Fonts" --which are the
> only two available to me from the properties menu of the cmd.exe window
I'm
> running sqlplus from.
>
> Where are the sqlplus font registry entries located?
>
> Thanks in advance.
>
> --steve
>
>
> <Christopher.Jones_at_oracle.comX> wrote in message
> news:uk7mr36mq.fsf_at_oracle.comX...
> > "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 Sat Aug 24 2002 - 00:00:31 CEST