Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can only see 2 columns in SQL*Plus

Re: Can only see 2 columns in SQL*Plus

From: tojo <Tojo_at_hotmail.com>
Date: Fri, 27 Feb 2004 09:09:12 +0100
Message-ID: <MPG.1aa91996e5c7af169896d8@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?

Received on Fri Feb 27 2004 - 02:09:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US