查询oracle 数字与字符混合列中的字符串
select distinct t.speed_rate from td.veh_upload_brake_aclrtn t where regexp_replace(t.speed_rate,’^[-+]?\d+(.\d+)?$’,”) is not null AND trunc(t.created_timstm)>=to_date(‘20161018’,’YYYYMMDD’);
查询oracle 数字与字符混合列中的字符串
select distinct t.speed_rate from td.veh_upload_brake_aclrtn t where regexp_replace(t.speed_rate,’^[-+]?\d+(.\d+)?$’,”) is not null AND trunc(t.created_timstm)>=to_date(‘20161018’,’YYYYMMDD’);