Re: All output in UPPER case and with s p a c e s in SQL*Plus

Thomas Reinartz <Thomas.Reinartz_at_debis.com> wrote in message news:<3c4d3a2e$1_at_netnews.web.de>...
> Hi,
>
> I'm doing "select * from table_name;" within SQL*Plus (Client 8.0.5, Server 8.1.
> 7, compatible mode 8.1.0) and I receive strange output. It looks something like
>
> C O L U M N N A M E
> ----------------------
> R O W 1
> R O W 2
> A N D S O O N
>
>
> All output is in upper case and has spaces between the letters. Using TOAD I see no output at all.
>
> Somebody with an idea?
>
> Thanks in advance
>
> Thomas

Thomas, does this happen for all queries or just queries to this one table?

If all queries then, this is just a wild guess, but check the nls character set in use on the client and on the database. If one of the other was set to a two-byte character set then maybe that would account for the display. That is the only thing that comes to mind.

If it is only the one table then try selecting the data using the dump function to see if newlines, carriage returns, vertical tabs etc... are stored in the table data. Their presence will affect the display.

• Mark D Powell --