Hi,
I think there isn't anything similar.
But if you need it you can write it yourself, a simple example could be:
Code:
create or replace function isnumeric (param in char) return boolean as
dummy varchar2(100);
begin
dummy:=to_char(to_number(param));
return(true);
exception
when others then
return (false);
end;
/
I don't see any reason for using TO_CHAR(TO_NUMBER()) when a single TO_NUMBER would do:
Code:
create or replace function isnumeric (param in varchar2) return boolean as
dummy number;
begin
dummy:=to_number(param);
return(true);
exception
when others then
return (false);
end;
/
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Yes, that's pure truth.
I cut it from another piece of code and made some adjustments and I overlooked that.
Sorry for that and hope I didn't confuse anybody.
Thanks Jurij for correction.
Ales