Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP !!!! Simple problem...
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
![]() |
![]() |