Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: function refuses to work in where clause??
There's nothing obviously wrong here. Have you tried some simpler tests
like:
select account_number,is_rejecting_fn(account_number) from orders;
and
select account_number,1 from orders where
is_rejecting_fn(account_number)=1;
?
Are the results correct?
![]() |
![]() |