Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query resulting inconsistent results

729555Apr 24 2010 — edited Apr 24 2010
Hi,

I'm running Oracle 10.2.0.4 and have a partitioned table.
When I run the query

select bse_rem_bse, ben_aly_num from dw_cn2.prs_old
where bse_rem_bse = 3

I'm getting records with null data (i.e. bse_rem_bse is 'null') and the correct data (i.e. bse_rem_bse is 3).
bse_rem_bse is a number type data field.

Can anyone help me understanding the inconsistent result
and how to find what's broken in table.

Thanks
Tarun
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2010
Added on Apr 24 2010
2 comments
772 views