Re: Filter operation

From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Tue, 23 Mar 2010 13:16:50 -0400
Message-ID: <49d668001003231016q590b3d4dv533f6d8a80c6209b_at_mail.gmail.com>

"dont understand very well why those two conditions why will always results in FALSE?"

I never said that they will. Please look and read more carefully and you'll see that the predicate which I've used is the opposite to what you really have.

On Tue, Mar 23, 2010 at 1:00 PM, LS Cheng <exriscer_at_gmail.com> wrote:
> Hi Alex
>
> dont understand very well why those two conditions why will always results
> in FALSE?
>
> I have two FILTER operations
>
>
>    2 -
> filter(ADD_MONTHS(TRUNC(SYSDATE_at_!,'fmmm'),-1)<TRUNC(SYSDATE@!,'fmmm'))
>    4 - filter("MF"."F_PERIOD">=ADD_MONTHS(TRUNC(SYSDATE_at_!,'fmmm'),-1) AND
>               "MF"."F_PERIOD"<TRUNC(SYSDATE_at_!,'fmmm'))
>
> For step 4 I understand that Filter is requiered but step 2....
>
>
>
> Thanks!
>
> --
> LSC
>
> On Tue, Mar 23, 2010 at 5:09 PM, Alex Fatkulin <afatkulin_at_gmail.com> wrote:
>>

-- 
Alex Fatkulin,
http://afatkulin.blogspot.com
http://www.linkedin.com/in/alexfatkulin
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 23 2010 - 12:16:50 CDT