Hi Guys, i would like to share with you what is going on in one of my applications.
I got the partition table, each partition has got one month data. i ran some queries on one of the partition, i got the results back with some values. but they were not addind up the total sum.
Here is my table and querys. I would be appriciate your openion.

sql> dec Jun2001
opc varchar2(11),
dpc varchar2(11),
mess_time date,
mess_num number(5),
mcount number(5),
p_id number(3)

Query:

select sum(mcount)
from jun2001
where to_char(mess_time, 'YYMMDDHH') = '01062910'
and dpc = '111.151.101'
or opc = '111.151.101'; --- BAD RESULTS

select sum(mcount)
from jun2001
where to_char(mess_time, 'YYMMDDHH') = '01062910'
and dpc = '111.151.101';


Thanks