Re: Strange behavior with SQLPLUS (Oracle)

dba_222_at_yahoo.com (Roger Redford) writes:

If COLUMN has the effect you want, then I think it will be a SQL*Plus issue.

Depending what part of your setup is "new", my guesses for the cause are:

    (i) a new version of the server optimizes buffer     allocations differently, or needs to cater for different     character sets. SQL functions like SUBSTR will display     different default column widths then you were used to.

    (ii) Different Oracle NLS settings cause buffer     expansion.

Since your neighbor's terminal is OK then I would triple-check your "copying environments" test.

Perhaps using the web based iSQL*Plus will help in general? Because it uses HTML tables the browser does most of the column resizing.

Chris

> 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

-- 
Christopher Jones, Oracle Corporation, Australia.