e DBA
> -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
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 rep
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 f
lto:[EMAIL PROTECTED] 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 Bo
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
> 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 v$type_si
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 n
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
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 Poder
Before the "deterministic" qualifications, there was only one way
to use a user defined function in the select list of a query:
it was
PRAGMA RESTRICT_REFERENCES(WNDS,WNPS)
The only place where you could do it was in a package. In other
words, if a user defined function was to be used in the select
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 exa
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 recipi
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;
/
--
M
day, 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
> can definnitely accomplish this by writing your own function
> something
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;
/
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL
003 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
> can definnitely accomplish this by writing your own function
> something like
> function isNum(a
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,
>
>
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
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 (nu
19 matches
Mail list logo
