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

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP !!!! Simple problem...

Re: HELP !!!! Simple problem...

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Mon, 19 Jul 1999 12:11:44 -0400
Message-ID: <37934E3F.C0B3AEA3@Unforgettable.com>


Dhiru Pankhania wrote:

> I am a real newbie - taking courses / learning on line, etc
>
> I have personal edition of oracle 8.0.4. on my home computer - works
> fine.
> I have created some tables for exercise purposes. One table is 9
> columns across.
> The problem seems to be in the display of the data.
> Example: A select statement (select * from <table>;) displays only
> six columns (even when I scroll to the extreme right!! Now I know these
> columns exist because a describe statement defines the table exactly.
> Also a select statement calling for the extreme right columns displays
> them correctly.
>
> Please help - this is frustrating - I am always misled that those
> columns have not been defined/created!!!!
>
> I tried changing "LINESIZE" option - no can do
>
> I NEED HELP..
>
> Thanks - appreciate it.
>
> reply to: ez52116_at_bossk.mar.lmco.com
> and / or dzeepan_at_cs.com

Do you have headings turned off? Are the columns populated with data? Do you have wrap turned off? Is your glogin.sql or login.sql doing anything strange?

Also, try this - enter:
SET NULL "EMPTY" and then repeat your select statement.

Ken Received on Mon Jul 19 1999 - 11:11:44 CDT

Original text of this message

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