Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: equivalent for isdate, isnumeric

Re: equivalent for isdate, isnumeric

From: Vladimir Begun <>
Date: Thu, 25 Sep 2003 21:49:40 -0800
Message-ID: <>

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.
> >
> 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: -- Author: Vladimir Begun INET: Fat City Network Services -- 858-538-5051 San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: (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).
Received on Fri Sep 26 2003 - 00:49:40 CDT

Original text of this message