Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: equivalent for isdate, isnumeric
Khedr, Waleed wrote:
> Boolean is A PL/SQL data type won't work in sql.
> Deterministic is nice to have to reduce the number of times this function
> gets called for the same value.
Called from where? :) I think Tanel, Mladen and you missed the ironical point -- if it can't be called from SQL why it is a deterministic one?
It was very simple question asked for fun -- Mladen who said: "Hey, I'll sue you for using my code. My code is fair and balanced and you cannot use it without paying royalties." :) So, he put "deterministic" clause then. :)
P.S.: Tanel, I do not need an example, it was a joke.
-- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation.Received on Fri Sep 26 2003 - 00:49:40 CDT
> -----Original Message-----
> Sent: Thursday, September 25, 2003 10:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Tanel Poder wrote:
>
>>Boolean is a datatype existing and usable in Oracle.
>
> > Deterministic is an Oracle way to tell a function is deterministic, i.e.
> > always returning the same result on the same input. Required for FBIs for
> > example.
> > http://tahiti.oracle.com
>
> Could you please kindly provide an example of its usage in SQL. Please
> create
> an FBI using the original function below (as is, no modifications or
> wrappers).
> It would be really intersting how "deterministic" functionality would work
> for a PL/SQL function that returns BOOLEAN datatype. Thank you!
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun INET: vladimir.begun_at_oracle.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).