Re: Strange behavior with SQLPLUS (Oracle)

Hi guys,

Thanks for all your responses. With sqlplus I tried all these things: set trimspool on/off
set linesize
copying environments

and it made no difference. I still had the same symptom.

Only formatting the column works. Which, as I mentioned, is a lot more work for every ad hoc query.

I'm thinking that this is really not a sqlplus issue, but a terminal issue. Any ideas?

Thanks

dba_222_at_yahoo.com (Roger Redford) wrote in message news:<a8c29269.0301140753.7ee5175c_at_posting.google.com>...
> I've recently moved to a new environment, and I'm getting some strange
> symptoms with sqlplus. The environment is:
>
> Oracle 9.2, on solaris
> Ibm thinkpad laptop
> Smarterm and Putty
>
> I've used both Smarterm and Putty to connect to unix and use sqlplus. It is
> using SSH, but the symptoms occur whether I am just using telnet, or ssh.
>
>
> The symptom is:
>
> When do I select some long columns, such as TABLE_OWNER,
> OR table_name, the field takes up a whole line.
>
>
> IE.
>
> Select table_owner ,
> table_name ,
> partition_name,
> NUM_ROWS,
> LAST_ANALYZED
> from all_tab_partitions
> where NUM_ROWS = 0
> ORDER BY TABLE_OWNER,
> TABLE_NAME,
> PARTITION_NAME
>
>
> I have tried:
> set linesize 30000
> substr(table_owner, 1, 20) as table_owner
>
> Yet, no matter what I do, the symptoms persist.
>
> Set wrap is on. If I set it off, I will only see the first field.
>
> The crazy thing is, that my neighbors' sqlplus works normally,
> and only returns 30 or less columns.
>
>
> Is there a setting that I should be concerned about? Is it in
> sqlplus, or in the client software (Putty, or Smarterm)?
>
>
> Thanks
Received on Fri Jan 17 2003 - 15:17:46 CST