Re: Can only see 2 columns in SQL*Plus

You're right! The column was 100 chars. I set WRAP on, but then the lines wrapped making everything almost unreadable. However, the answer was to limit the wide columns using following command:

COLUMN col FORMAT A15 WRAP

where 'col' is the name of the column. In this example the column uses no more than 15 chars, and wraps within the column!

Rgds
Peter

tojo <Tojo_at_hotmail.com> wrote in message news:<MPG.1aa91996e5c7af169896d8_at_news.t-online.de>...
> In article <68d3c32.0402261352.73fdadf2_at_posting.google.com>,
> deleteallspam_at_yahoo.com says...
> > When I write
> > SELECT * FROM mytable;
> > I only get the two first columns, no matter how many columns there are
> > in the table. I can do SELECT on each or several columns in the table,
> > but there are never more than two displayed in the output.
> >
> > I can't find a suitable setting to specify "all" columns. Ideas,
> > please?
> >
> > Rgds
> > Peter
> >
> What does "desc mytable" say? Maybe the 2nd column is a long VARCHAR and
> other columns are getting pushed off the screen?
>
> -- Tom
Received on Tue Mar 09 2004 - 11:30:59 CST