Re: strange behaviour in select statement

From: stephen booth <stephenbooth.uk_at_gmail.com>
Date: Fri, 28 Oct 2005 09:02:03 +0100
Message-ID: <687bf9c40510280102h6192bd57s@mail.gmail.com>

On 28/10/05, raja rao <raja4list_at_yahoo.com> 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

Received on Fri Oct 28 2005 - 03:04:50 CDT