Re: Strange behavior with SQLPLUS (Oracle)

Thanks for responding.

I did know about formatting, and this does work. But it's double the work to format each column every time you run a query.

Even using substr(field, 1, 10) should only return the number of characters specified. Currently, even using substr returns an entire line, no matter how long the line is.

Does anyone know how to make it work normally?

Eric Kimble <ekimble_at_wfl.fha.dot.gov> wrote in message news:<3E2437A7.8FBD4FB7_at_wfl.fha.dot.gov>...
> 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 Wed Jan 15 2003 - 10:01:24 CST