Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Function Question
foo will be called two times.
Hth,
Sybrand Bakker, Oracle DBA
Moore <rlmoore_at_purdue.edu> wrote in message
news:Pine.SOL.4.10.10003131226280.23835-100000_at_herald.cc.purdue.edu...
> Greetings!
>
> In the following will function foo be called twice per tupple?
>
> Select Distinct ID_Field, Date_Field, FOO(ID_Field, Date_Field)
> From Table
> Where Date_Field > To_Date('01-JAN-99', 'DD-MON-YY')
> AND FOO(ID_Field, Date_Field) > 0;
>
> By the way I already attempted:
>
> Select Distinct ID_Field, Date_Field, FOO(ID_Field, Date_Field) Foo_Field
> From Table
> Where Date_Field > To_Date('01-JAN-99', 'DD-MON-YY')
> AND Foo_Field > 0;
>
> Also attempted AS Foo_Field and "Foo Field".
>
> TIA
>
Received on Mon Mar 13 2000 - 12:08:32 CST