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 -> Can only see 2 columns in SQL*Plus

Can only see 2 columns in SQL*Plus

From: PL <deleteallspam_at_yahoo.com>
Date: 26 Feb 2004 13:52:50 -0800
Message-ID: <68d3c32.0402261352.73fdadf2@posting.google.com>


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 Received on Thu Feb 26 2004 - 15:52:50 CST

Original text of this message

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