Re: Index question
Date: Wed, 26 Aug 2009 20:39:23 +0200
Message-ID: <4a958160$0$2847$ba620e4c_at_news.skynet.be>
"Steve Howard" <stevedhoward_at_gmail.com> wrote in message
news:5534f3df-6650-4583-99d2-e3a4fbcf23ea_at_g31g2000yqc.googlegroups.com...
> Hi All,
>
> 10.2.0.4 EE three node RAC on SLES 10
>
> I'm fairly sure I am missing something, but can someone please explain
> what is below?
>
> SQL> select min(jrn_seq) from xwc.xwc_change_history where jrn_seq
> between 1019514060 and 1019514080;
>
> MIN(JRN_SEQ)
> ------------
> 1019514075
>
> SQL> select jrn_seq from xwc.xwc_change_history where jrn_seq between
> 1019514060 and 1019514080 order by 1;
>
> JRN_SEQ
> ----------
> 1019514072
> 1019514073
> 1019514074
> 1019514075
> 1019514076
> 1019514077
> 1019514078
> 1019514079
> 1019514080
>
> 9 rows selected.
>
> SQL>
>
> Thanks,
>
> Steve
Wow! And this is 10.2.0.4? So after all these years Oracle can't even return the *correct* results??? Makes me wonder...
Matthias Received on Wed Aug 26 2009 - 13:39:23 CDT