Re: Strange behavior with SQLPLUS (Oracle)

Roger:
In SQL*Plus, when only wanting to look at a portion of the column you need to tell the environment to only show the portion that you want. issue a statement like the following on the SQL*Plus command line

column table_name format a30.

Then read up on column formatting in the documentation at tahiti.oracle.com

Roger Redford wrote:

> 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 Tue Jan 14 2003 - 10:15:35 CST