Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can only see 2 columns in SQL*Plus
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?