strange behaviour in select statement

From: raja rao <raja4list_at_yahoo.com>
Date: Fri, 28 Oct 2005 00:13:54 -0700 (PDT)
Message-ID: <20051028071354.21903.qmail@web31409.mail.mud.yahoo.com>

HI All,  

My simple select statemnt is giving improper results from a table which has only 1 row.  

The below is the case:  

SQL> select hospital_id from image_staging_table ; HOSPITAL_ID

---

ASHFORD   SQL> select hospital_id, acct# from image_staging_table; HOSPITAL_ID ACCT#
--------------- ------------------------------

        X104978978  

SQL> select acct# from image_staging_table; ACCT#

---

X104978978
SQL>   when i select more than 1 column, some colums data is missing. Am i missing something to setup.  

Thanks,
Raj                   

---

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

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 28 2005 - 02:16:52 CDT