22,209
社区成员
发帖
与我相关
我的任务
分享
DELETE FROM 表
WHERE ISNUMERIC(字符列) = 0
select
cast(col as float) col
from table1
where isnumeric(col) = 1
SELECT *
FROM tb
WHERE ISNUMERIC(字段名)=1 --查出是数字的记录
where isnumeric(col) = 1
select * from table1 where upper(column1)=TRANSLATE (upper(column1), '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ', '0123456789');
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;