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?
Erm.. ee.. if you put a wrapper function over it which retuns number...
(just joking)
Ok, I was too short-sighted there. I just checked from
Title: RE: equivalent for isdate, isnumeric
you could however use diutil.bool_to_int and diutil.int_to_bool which is used by oracle to transmit/receive Boolean data across SqlNet.
Since others have pointed out, Boolean is not a SQL datatype, you could not build a FBI around it, deterministic
] On Behalf Of
Jamadagni, RajendraSent: Friday, September 26, 2003 10:05
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
equivalent for isdate, isnumeric
you could however use diutil.bool_to_int and
diutil.int_to_bool which is used by oracle to transmit/receive Boolean data
Tanel Poder wrote:
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?
Erm.. ee.. if you put a wrapper function over it which retuns number...
(just joking)
Ok, I was too short-sighted there. I just checked
Mladen Gogala wrote:
Or, the function can be written to return number. It's not so hard to
do. If there are problems,
please let me know, I'll post the new version of the code, wrapped.
Thank you. :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of AK
Sent: Thursday, September 25, 2003 12:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: equivalent for isdate, isnumeric
I am not sure if there is any such function in 9i . But you
Hi All,
I am investigating an effort to move our product into Oracle from SQL Server. Came
across the function isnumeric, isdate in SQL Server that returns true or false if the
input string is in a form that can be converted into a numeric or date type. searched
in oracle help and am not
I am not sure if there is any such function in 9i . But you can definnitely
accomplish this by writing your own function something like
function isNum(a varchar2) returns boolean is
begin
b := tonumber(a);
result = true;
return result;
exception
when
Title: RE: equivalent for isdate, isnumeric
to_date, to_number
-Original Message-
From: Shiva Maran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 25, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L
Subject: equivalent for isdate, isnumeric
Hi All,
I am
This topic came up earlier this week, so just look
it up in you mail.
Or check out the archives at www.fatcity.com.
Archives are available at a number of unauthorized
locations near you: www.faqchest.com is one I believe.
Jared
On Thu, 2003-09-25 at 08:34, Shiva Maran wrote:
Hi All,
I
To: Multiple recipients of list ORACLE-L
Subject: Re: equivalent for isdate, isnumeric
I am not sure if there is any such function in 9i . But you
can definnitely accomplish this by writing your own function
something like
function isNum(a varchar2) returns boolean is
begin
b
PROTECTED] On
Behalf Of Shiva Maran
Sent: Thursday, September 25, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L
Subject: equivalent for isdate, isnumeric
Hi All,
I am investigating an effort to move our product into
Oracle from SQL Server. Came across the function isnumeric
of list ORACLE-L
Subject: Re: equivalent for isdate, isnumeric
I am not sure if there is any such function in 9i . But you
can definnitely accomplish this by writing your own function
something like
function isNum(a varchar2) returns boolean is
begin
b := tonumber
boolean is not SQL datatype and it's unclear what deterministic
means here.
Mladen Gogala wrote:
create or replace function
isnumeric(str varchar2) return boolean deterministic
as
num number:=0;
begin
num:=to_number(str);
return(true);
exception
when others then
return(false);
end;
/
--
Hi!
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
Tanel.
- Original Message -
To: Multiple
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
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.
Regards,
Waleed
-Original Message-
Sent: Thursday, September 25, 2003 10:05 PM
To: Multiple recipients of list ORACLE-L
Tanel
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
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
19 matches
Mail list logo