RE: strange behaviour in select statement

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Fri, 28 Oct 2005 08:41:53 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF35FD82@EXCNYSM0A1AJ.nysemail.nyenet>

Raja,  

I would take a look at the data in the two columns. My guess is that you have a hidden character someplace (like a carriage return) that is causing the data to be overwritten.  

Run a "select dump(hospital_id), dump(acct#) from table" and look at the results.  

Also run your original sql on a different machine. Like sqlplus on a desktop, then sqlplus on a unix server, or sqlplus as a dos prompt. You will probably see different results.  

Tom  

---

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://us.lrd.yahoo.com/_ylc=X3oDMTFqODRtdXQ4BF9TAzMyOTc1MDIEX3MDOTY2OD gxNjkEcG9zAzEEc2VjA21haWwtZm9vdGVyBHNsawNmYw--/SIG=110oav78o/**http%3a/f arechase.yahoo.com/>

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

Received on Fri Oct 28 2005 - 07:44:41 CDT