Message-ID: <F001.005D1176.20030925224444@fatcity.com>
Date: Thu, 25 Sep 2003 22:44:44 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Khedr, Waleed" <Waleed.Khedr@FMR.COM>
Subject: RE: equivalent for isdate, isnumeric
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

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@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@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@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@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).