RE: equivalent for isdate, isnumeric

I was just explaining Deterministic independently of the function.

-----Original Message-----
Sent: Friday, September 26, 2003 1:50 AM To: Multiple recipients of list ORACLE-L

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.



> -----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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.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).