Re: Can only see 2 columns in SQL*Plus

You could also have issued a
linesize 250
 ( for instance)
and
all the data would have been displayed ( up to 250 chars).

you can set this to almost any number..I've never gone beyond 1000 though.

deleteallspam_at_yahoo.com (PL) wrote:

>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 - 12:05:50 CST