Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: function refuses to work in where clause??

Re: function refuses to work in where clause??

From: Jerome Vitalis <vitalis..._at_gmail.com>
Date: 16 Oct 2007 08:05:58 GMT
Message-ID: <471470e6$0$12480$426a74cc@news.free.fr>


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?



échangez opinions et commentaires dans les forums de discussion. http://www.usenetgratuit.com/ Received on Tue Oct 16 2007 - 03:05:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US