Re: Filter operation
- From: Alex Fatkulin <afatkulin@xxxxxxxxx>
- To: LS Cheng <exriscer@xxxxxxxxx>
- Date: Tue, 23 Mar 2010 13:16:50 -0400
"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@xxxxxxxxx> 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@!,'fmmm'),-1)<TRUNC(SYSDATE@!,'fmmm'))
> 4 - filter("MF"."F_PERIOD">=ADD_MONTHS(TRUNC(SYSDATE@!,'fmmm'),-1) AND
> "MF"."F_PERIOD"<TRUNC(SYSDATE@!,'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@xxxxxxxxx> wrote:
>>
--
Alex Fatkulin,
http://afatkulin.blogspot.com
http://www.linkedin.com/in/alexfatkulin
--
//www.freelists.org/webpage/oracle-l
Other related posts:
