Is there a built-in function to check if a string is a number?
407338Jul 29 2010 — edited Jul 29 2010Hi all,
In Oracle, is there a built-in function that checks if a string (varchar2) is a number? So far I have not found one and I may have missed it in the documents, so I have had to use a block like
begin
v_number := to_number(v_string);
exception when others then
v_number := 0;
end;
if v_number > 0 then
....
end if;
Thank you.
Ben