strange behaviour in select statement
- From: raja rao <raja4list@xxxxxxxxx>
- To: oracle list <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 28 Oct 2005 00:13:54 -0700 (PDT)
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.
Other related posts:
