RE: strange behaviour in select statement

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Fri, 28 Oct 2005 09:09:55 -0400
Message-ID: <KNEIIDHFLNJDHOOCFCDKMELDHCAA.mwf@rsiz.com>

Oh, and set echo on and autotrace on so we can see this isn't a trigger trick. That is probably the shortest route to de-mystification.

mwf
  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of raja rao   Sent: Friday, October 28, 2005 8:34 AM   To: stephen booth
  Cc: oracle list
  Subject: Re: strange behaviour in select statement

Hi,

Thanks for your reply.

If the below is true:

HOSPITAL_ID ACCT#

------------- ASHFORD [NULL] [NULL] X104978978

the select count(*) should result 2 rows. However, my select count(*) is giving one only.

and when i select a specific col, it is giving value and the feeback is 1 row.

stephen booth <stephenbooth.uk_at_gmail.com> wrote: 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 th an to make a silly assumption.

--
  Yahoo! FareChase - Search multiple travel sites in one click.



--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 28 2005 - 08:14:46 CDT