RE: strange behaviour in select statement

From: raja rao <raja4list_at_yahoo.com>
Date: Fri, 28 Oct 2005 05:31:51 -0700 (PDT)
Message-ID: <20051028123152.61628.qmail@web31406.mail.mud.yahoo.com>

Yes, this is a heap table (not temporary table / view )

Lex de Haan <lex.de.haan_at_naturaljoin.nl> wrote: also, is this a "regular" heap table?
or maybe a view with a hidden ROWNUM predicate? or an external table, or a global temporary table?

kind regards,

Lex.

Jonathan Lewis Seminar http://www.naturaljoin.nl/events/seminars.html

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of stephen booth
Sent: Friday, October 28, 2005 10:02
To: raja4list_at_yahoo.com
Cc: oracle list
Subject: Re: strange behaviour in select statement

On 28/10/05, raja rao wrote:
>
> when i select more than 1 column, some colums data is missing. Am i
> missing something to setup.
>

The first thing that leaps to mind to try to identify the problem is to use NVL() on both columns in your select to display something (the string 'this is NULL' for example) if the value is null, or maybe do a select count(*) from image_staging_table; to check there's only one row.

It's possible that your table might have two rows looking like:

HOSPITAL_ID ACCT#

----------------- -------------

ASHFORD [NULL]
[NULL] X104978978 rather than one row such as:

HOSPITAL_ID ACCT#

----------------- -------------

ASHFORD X104978978 which is what you are presumably expecting.

Stephen

--
It's better to ask a silly question than to make a silly assumption.
--
http://www.freelists.org/webpage/oracle-l

BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583 SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan_at_naturaljoin.nl
REV:20040224T160439Z
END:VCARD


		
---------------------------------
 Yahoo! FareChase - Search multiple travel sites in one click.  
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 28 2005 - 07:34:29 CDT